Help debugging in SQLPLUS

From: Jim Bridges <jbridges_at_cup.hp.com>
Date: Thu, 1 Dec 1994 18:11:49 GMT
Message-ID: <D0597q.7BD_at_cup.hp.com>


I would like to use SQLPLUS (3.1.3.2.1) to debug a stored procedure.

If I have OUT parameters, I would like to place these in an SQLPLUS variable that I have bound (using the VAR command).

Is this possible? How?

For example, I can execute

execute hpodbss.get_client('1234',myname);

where '1234' is a phone number and I want the name associated with it.

From the error msg, it is clear that "myname" is unknown inside the command.

Could some of you experts out there answer this? Also, can anyone recommend a good book - one that is NOT written by Oracle. Received on Thu Dec 01 1994 - 19:11:49 CET

Original text of this message