Hello
I need to migrate an application written in C sharp that connects to an oracle database to Postgres.
Having issues with out parameters.
I have two parameters abc and xyz. Xyz is an out parameter.
The code for oracle uses the following line to create a parameter.
Var xyz = database.create parameter(xyz, refcursor, parameterdirect ion.output,null ).
But I get a message saying “parameter cuz referenced is sql is an out only parameter. ).
I tried all combinations but the only combination that worked is
Database.create parameter(xyz, refcursor , “test”)
But when I run the command in pgadmin
I do a call storedprocedure name(abc value, null) then it works.
But I’m confused. I’ve read online for two days but still confused.
I need to migrate an application written in C sharp that connects to an oracle database to Postgres.
Having issues with out parameters.
I have two parameters abc and xyz. Xyz is an out parameter.
The code for oracle uses the following line to create a parameter.
Var xyz = database.create parameter(xyz, refcursor, parameterdirect ion.output,null ).
But I get a message saying “parameter cuz referenced is sql is an out only parameter. ).
I tried all combinations but the only combination that worked is
Database.create parameter(xyz, refcursor , “test”)
But when I run the command in pgadmin
I do a call storedprocedure name(abc value, null) then it works.
But I’m confused. I’ve read online for two days but still confused.