I am facing some problem with Oracle's CLOB datatype.
For a COLB datatype column in the Oracle when I specify Varchar(2000) in server job it gives me
error ORA-24909: call in progress. Current operation cancelled
The description of the Error (from a site)
If I use LongVarchar(2000) in place of Varchar(2000), Job runs fine.ORA-24909: call in progress. Current operation cancelled
Cause: The OCI call was invoked when another call on the connection was in progress.
Action: Check if the OCI call is supported when the call is in progress under special conditions; for example, if it is being used by a signal handler.
I suppose the datatype within the Datastage is just for the purpose of documentation, it treats everything as characters only (except validation)(correct me if I am wrong).
So the question is what changes when it becomes longvarchar instead varchar, more over can I achieve it through varchar also?
The length of the test data that I am using for CLOB column is not more than few characters.