New topic: Returning values from Oracle Procedures
<http://forums.realsoftware.com/viewtopic.php?t=47376> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message mauriciolives Post subject: Returning values from Oracle ProceduresPosted: Fri Mar 22, 2013 6:41 pm Joined: Fri Mar 22, 2013 6:31 pm Posts: 1 Hi ! I need some help on oracle procedures: example: I want to pass one parameter and to receive one on real basic. Oracle Procedure on database: myprocedure(ORDER IN VARCHAR2, RETORNO OUT VARCHAR2) IS BEGIN INSERT INTO ...... VALUES ( ORDER ); -- this line works ! RETORNO:="OK - RETURNING TO REALBASIC" EXCEPTION WHEN OTHERS THEN RETORNO:="ERROR - RETURNING TO REALBASIC" END; I want to receive ( RETORNO ) into a variable in realbasic dim zorder,retvalue as string zorder = "1000" retvalue = "" db.sqlexecute("begin myprocedure(" + zorder + "," + retvalue + "); end;") i want retvalue with value returning from oracle procedure, i can pass it to procedure, how do i receive the value returning into retvalue variable ? Please help me. Thanks Mauricio END; Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
