Search Results

I am getting error when loading data file using ctl file. I get this error only when there is special character.
Below is some data.


DataFile=>
...

Truncating data will not be good idea as it has dependency on many tables.
But if there is not solution then have to go deep level to truncate data in all dependent tables which is not good...

I have code to update some records in MyTable1 in sql which I am calling from ksh file (unix script).
I am getting below error -
MyTable1 TABLE UPDATE FAILED : UPDATE MyTable1 SET ph_nr = '+44...

Hi All,

I have cursor which is about to fetch 4,00,000 records and then I am performing the action in cursor.

I am running this sql using unix script.

But after some time , I see the job is...

Hi scottn,

Thanks...

That is correct reason that \ is causing update twice. But why \ is causing twice update?

-thanks

Example 1=>
I have unix ksh file and I am calling sql file from it.



(table 1 contains 2 rows -
ID Name
1 test't
2 Pet's
)

below sql statement is part of sql file:
...