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