All --
I have an OCI program which is creating PL/SQL. If the string I pass to
OCIExecute has a '\r' character, this is flagged as a syntax error. So,
some questions:
- If I use the text file from which came the creation text in sqlplus,
everything works fine: I presume sqlplus is filtering the text? (I know
that it removes blank lines, and the like).
- Is there some cannonical form that the OCI/PL/SQL compiler expects to
be passed? For what other characters should I filter?
- I'm using 8.1.5 on Linux: is the cannonical form for text to pass to
the PL/SQL execution engine different on Windows?
- Is there any documentation on this anywhere? I can't find it in the
OCI manual.
- In my program, if I pass text with a '\r' I get a segmentation fault
within OCILogoff. Same text w/out the \r works fine. I don't believe
that my program is sensitive to \r characters (and so might be
overwriting the env and err memory areas). Is this a bug with the OCI
that anyone has heard about before?
Many thanks,
Arien
Received on Wed Sep 01 1999 - 12:40:40 CDT
