[
https://jira.codehaus.org/browse/MSQL-68?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=275744#comment-275744
]
Robert Scholte commented on MSQL-68:
------------------------------------
Did you change the delimiterType to {{row}}?
> Create procedure with comment /* .. */
> ------------------------------------------
>
> Key: MSQL-68
> URL: https://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.
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
