EOracleError ora-1480 ?????

[hivaj]

I'm trying to execute block PL/SQL, but i receive the erro ora-1480.

I have variable with value blank or null, I not put value into variable, exists some problem.

Thanks

 

[Marco Kalter]

Could it be that you are passing a value longer than 4000 bytes to a otString variable? For PL/SQL strings, you can use the otPLSQLString variable for strings up to 32KB.

------------------
Marco Kalter
Allround Automations

 

[J_Pygram]

Hivaj,
You must set any variables before execution of the SQL otherwise you will get an error unless you have already run the query then it will use the last value. You can set NULL values and empty strings but you must set something. Good luck.
John