Page 1 of 1

Error in Oracle Stage

Posted: Tue Aug 11, 2009 3:44 pm
by dganeshm
Fatal Error :

Update_Repl_Parts: The provided insert statement did not prepare correctly;
please verify that your statement is correct;
statement: INSERT INTO INTF_ORIG_REPL_PART (SC_AUTH_NUM, SC_ITEM_NUM, VID, REPL_PART_ID, Create_Dte, AUTH_FLG, AUTH_PART_ID) VALUES ( :SC_AUTH_NUM, :SC_ITEM_NUM, :VID, :REPL_PART_ID, :Create_Dte, :AUTH_FLG, :AUTH_PART_ID).
Unable to find a free dynamic SQL instance.
Error: Instance number must be 0 <= -1 <= 9


There is an information before this error : main_program: -nchar_cs option is deprecated.
-nchar_cs option is deprecated.
-nchar_cs option is deprecated.
-nchar_cs option is deprecated.
-nchar_cs option is deprecated.
-nchar_cs option is deprecated.
-nchar_cs option is deprecated.
-nchar_cs option is deprecated.

Can someone help ASAP , thanks in advance.

Posted: Wed Aug 12, 2009 12:36 am
by ArndW
I would suggest looking for a paid-for service for "ASAP" support, this is a volunteer forum.

Could your problem be this IBM APAR?

Posted: Fri Aug 14, 2009 10:54 am
by dganeshm
ArndW wrote:I would suggest looking for a paid-for service for "ASAP" support, this is a volunteer forum.

Could your problem be this IBM APAR?
Thanks ArndW..the patch worked..