How to dbImport in Informix?

1. dbimport <database_name> -d <dbspace_name> -l buffered

NOTE: l = small L

2. ontape -s -B <database_name>

3. Go to the folder <database_name>.exp

4. dbaccess <database_name> pp.sql

PLS-00123: Program Too Large when compile invalid objects in PL/ SQL ?

Go to PL/ SQL -> Tools -> Preferences -> Oracle Debugger:

a). Un-check the "Add debug information when compiling".

b). Click the "Apply" button.

c). Click the "OK" button.

d). Compile invalid objects now.

NOTE: In case you want to debug your package in PL/ SQL, you will need to check the "Add debug information when compiling" checkbox.

Set Define Off in Oracle

Oracle will ask you to enter the value if your UPDATE statement is written as below:

Update my_table Set my_field = 'You & I are good boy';

At the end, the value for my_field will not be updated even you have entered something.

To overcome this problem, you just need to add one more statement before the UPDATE statement:

Set Define Off;
Update my_table Set my_field = 'You & I are good boy';


NOTE: This topic also related to DELETE or INSERT INTO statement.