Calling Oracle Strored Procedure in ASP

Results 1 to 2 of 2

Thread: Calling Oracle Strored Procedure in ASP

  1. #1
    Jim Lossing Guest

    Default Calling Oracle Strored Procedure in ASP

    I can connect to Oracle without a problem, but can&#039t seem to get results from a simple Stored Procedure in Oracle.<BR><BR>Here is the Stored Procedure:<BR><BR>CREATE or REPLACE PROCEDURE sp_test <BR>( scan_code_in IN Char,<BR> return_sqlcode OUT Number<BR> )<BR>AS<BR>ls_book_status character;<BR>BEGIN<BR>return_sqlcode := 0;<BR>SELECT book_status<BR> INTO<BR> ls_book_status<BR>FROM dp260i.collection<BR> where scan_code = scan_code_in;<BR><BR>EXCEPTION<BR> WHEN NO_DATA_FOUND THEN<BR> return_sqlcode := +100; <BR><BR>END sp_test;<BR>/<BR><BR>This Stored Procedure will return either 0 or 1 rows because of the primary key on scan_code. I have tested the Stored Procedure and it works just fine.<BR><BR>Any help would be appreciated.<BR><BR>thanks,<BR>jim lossing

  2. #2
    Jim Lossing Guest

    Default RE: Calling Oracle Strored Procedure in ASP

    With no response, I continued to search. This web page had the answer!<BR><BR><BR><BR>Jim Lossing

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts