Hi,
Wrapped source with comment line gives compalation error ORA-24344 and
staus became invalid. I would like to know whether we can't use comment
like in the wrapped code or any other way to use comment line in wrapped
code.
Testcase:
***********
DECLARE
l_status VARCHAR2(128);
l_unwrapped VARCHAR2(4000) := 'create or replace procedure
SYSTEM.wrap_test
is
begin
if/* test */true then
null;
end if;
end wrap_test;';
l_wrapped VARCHAR2(4000);
BEGIN
l_wrapped := dbms_ddl.wrap(l_unwrapped);
EXECUTE immediate l_unwrapped;
SELECT status
INTO l_status
FROM dba_objects
WHERE owner = 'SYSTEM'
AND object_name = 'WRAP_TEST';
dbms_output.put_line('unwrapped status:'||l_status);
BEGIN
EXECUTE immediate l_wrapped;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('sql error message'||sqlerrm);
END;
SELECT status
INTO l_status
FROM dba_objects
WHERE owner = 'SYSTEM'
AND object_name = 'WRAP_TEST';
DBMS_OUTPUT.PUT_LINE('wrapped status:'||L_STATUS);
END;
Output:
*********
Created!
unwrapped status:VALID
Created!
sql error message ORA-24344: success with compilation error
wrapped status:INVALID
select text from USER_ERRORS where NAME = 'WRAP_TEST';
"PLS-00103: Encountered the symbol "THEN" when expecting one of the
following:
:= . ( @ % ;
"
Regards,
Sundar
--
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
---
You received this message because you are subscribed to the Google Groups
"Oracle PL/SQL" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to oracle-plsql+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
