Information générale
Titre:
Line Feed Character in a SQLEXEC SQL Statement -ORACLE
Please Help me!
I am having problems Creating Stored Prcoedures on ORACLE:
FOR Example:
IF I run.
#DEFINE cEndLine CHR(13)+CHR(10)
lcSQL="CREATE OR REPLACE PROCEDURE QUESTDELETE"+cEndLine
lcSQL=lcSQL+" ( table_name IN VARCHAR2,"+cEndLine
lcSQL=lcSQL+" WHERE_CLAUSE IN VARCHAR2 ) AS"+cEndLine
lcSQL=lcSQL+" cursor_name INTEGER;)"+cEndLine
lcSQL=lcSQL+" ret INTEGER;"+cEndLine
lcSQL=lcSQL+" BEGIN"+cEndLine
lcSQL=lcSQL+" cursor_name := DBMS_SQL.OPEN_CURSOR;"+cEndLine
lcSQL=lcSQL+" DBMS_SQL.PARSE(cursor_name, 'DELETE FROM '|| table_name||' WHERE '||where_clause, DBMS_SQL.v7);"+cEndLine
lcSQL=lcSQL+" ret := DBMS_SQL.EXECUTE(cursor_name);"+cEndLine
lcSQL=lcSQL+" DBMS_SQL.CLOSE_CURSOR(cursor_name); "+cEndLine
lcSQL=lcSQL+" DBMS_SQL.CLOSE_CURSOR(cursor_name); /*Test Comment*/"+cEndLine
lcSQL=lcSQL+" END QUESTDELETE;"+cEndLine
I get PL\SQL COmpilation Errors when I run :
SQLEXEC(h,lcsql)
IF I simply run a recompile on the server after I see the proc. is fine.
If I change CHR(13)+CHR(10) to nothing.
It complies from SQLEXEC but my bigger procedures don't all fit on one line and they show up as all one line (hard to read) in Oracles Apps.
ANyone every dealt with this.
What Can I use for
#DEFINE cEndLine CHR(13)+CHR(10)
TO make it compile OK from SQLEXEC.
Is there a connection attribute I'm missing?
Thanks
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement