how to retrieve the result in Oracle?
-
hi everybody! I am a beginner in PL/SQL.I am currently doing a project based on PL/SQL with java as front end. Basically I am developing an editor for PL/SQL. I want to know how could we retrieve the resulting statements of PL/SQL program that is executed in Oracle. for eg: how to retrieve the result of a query say, 'Query completed successfully' which is displayed in Oracle editor to the front end form. Does anybody know how to proceed with this? Kindly bear with me as am new to Code Project. If anybody of you know the answer, can you be so kind and respond me! Regards, Shalini
-
hi everybody! I am a beginner in PL/SQL.I am currently doing a project based on PL/SQL with java as front end. Basically I am developing an editor for PL/SQL. I want to know how could we retrieve the resulting statements of PL/SQL program that is executed in Oracle. for eg: how to retrieve the result of a query say, 'Query completed successfully' which is displayed in Oracle editor to the front end form. Does anybody know how to proceed with this? Kindly bear with me as am new to Code Project. If anybody of you know the answer, can you be so kind and respond me! Regards, Shalini
You need to return a cursor variable (see http://www.enterprisedt.com/publications/oracle/result_set.html[^]).