Pro*C versus Dynanic SQL

[sofiagomes]

Hello all!

Does anyone know about problems with Pro*C programs using stored procedures wich use dynamic sql (using dbms_sql package) ?

I have a program that simply came with ORA-01405 (fetched column is null) when i changed stored procedured to use dbms_sql package...
I tried to recompile but the execution doesn't go well...

Any help?

Thanks

 

[Dagon]

I think this is unlikely to be due to dbms_sql. It is more likely that your procedure is not functioning properly and is returning null into the output/return variables in your Pro*C program. Unless you have an indicator variable present, you will then get an ORA-1405.

Try putting indicator variables against any parameters that are passed to and from the stored procedure.