[
http://jira.codehaus.org/browse/MSQL-68?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Robert Scholte updated MSQL-68:
-------------------------------
Description:
It is not possible to execute this statement using DELIMITER = '/'.
{noformat}
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;
/
{noformat}
was:
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;
/
> 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 = '/'.
> {noformat}
> 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;
> /
> {noformat}
--
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
