Create procedure with comment /* .. */
------------------------------------------
Key: MSQL-68
URL: http://jira.codehaus.org/browse/MSQL-68
Project: Maven 2.x SQL Plugin
Issue Type: Bug
Affects Versions: 1.4
Environment: Oracle 10g DB
Reporter: Jochen Stiepel
It is not possible to execute this statement using DELIMITER = '/'.
create or replace procedure PR_CLEAR_A
(
i_strType in Varchar2
)
is
/******************************************************************************
commmennnnnnnttttttttt
******** procedure comment end ***********************************************/
p_strType Varchar2 (50);
--
cursor cur_schema_objects ( strType varchar2 ) is
select object_name from user_objects where object_type = upper(
strType );
rec_schema_objects cur_schema_objects%rowtype;
--
--
begin
--
begin
if i_strType is null or i_strType = '' then
p_strType := 'ALL';
else
p_strType := upper( i_strType );
end if;
end;
end;
/
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
