Re: pro c question

A copy of this was sent to "gndiving" <dwhite_at_vrinter.net> (if that email address didn't require changing) On Wed, 5 Jan 2000 20:12:03 -0500, you wrote:

>I am calling a stored procedure in 8.0.6 Oracle database from
>an embedded PL/SQL block in a Pro*C program.
>The program works on UNIX where it is linked against 8.0.6.0 database
>On VMS where it is linked against 8.0.5 It fails with the error
>- Invalid length inside variable character string.
>The host variables are declared locally.
>When I declare them globally or static the program works.
>Does this require an upgrade to 8.0.6 or a run-time library upgrade
>or some link option?
>
>
>Please reply to
>dwhite_at_mail.intracorp.com

lets see the code. need to see the host variable declaration and all of the operations you perform on it before getting to the embedded block.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jan 06 2000 - 06:12:50 CST