Sv: Passing strings through ProC++

I believe this is actually more a PL/SQL than a Pro*C issue.

I am not sure whether I quite understand the syntax of you example; I would write it as follows:

.....
EXEC SQL EXECUTE
DECLARE
    strWX VARCHAR2(10) := '''X'',''Y'''; BEGIN
    Package.Procedure1(strWX);
END;
END-EXEC;
.....

And indeed you are right, the variable strWX contains the string: 'X','Y'

Please note that this is NOT equivalent to passing two separate char parameters to your Package.Procedure1.

Hope this helps.

Cheers,
Johan

<shuchi_at_my-deja.com> skrev i en
nyhedsmeddelelse:7l7t45$gnf$1_at_nnrp1.deja.com...
> I am facing problems with passing strings through Pro C++ code.
> The problems looks something like follows:-
> EXEC SQL BEGIN
> strWX VARCHAR2 := '''X'',''Y'''
> Package.Procedure1(strWX);
> EXEC SQL END;
> Please suggest whether strWX would be interpreted as ('X','Y') or not?
> In case putting strWX : = '''X'',''Y''' does not end up as 'X','Y'
> what else should I do?
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Jun 28 1999 - 09:52:05 CDT