Does anybody incurred the problem after convert .pl to .exe when modules
include pl/sql block like following: 

my $sth = $dbh-> prepare( q{
                        BEGIN
                         :ret_value := func (:vTemplate,
:vTpCode,:vNode,:vTimeStamp);
                        END;} ) 
                || return "ErrorCode:: Cannot prepare the statement;


The run time error is :

DBD::Oracle::st execute failed: ORA-06550: line 1, column 1:
PLS-00103: Encountered the symbol "" when expecting one of the following:

    begin case declare exit for function goto if loop mod null
    package pragma procedure raise return select separate type
    update while with <an identifier> 
    <a double-quoted delimited-identifier>  <a bind variable> <<
    form table call close current define delete fetch lock insert
    open rollback savepoint set sql execute commit forall merge
    library OPERATOR_ <a single-quoted SQL string>  pipe (DBD ERROR:
 OCIStmtExecute) [for statement ``
                        BEGIN
                         :ret_value := func(:vTemplate,
:vTpCode,:vNode,:vTimeStamp);
                        END;'' with params: :vTemplate='transstatus',
 :vTpCode='MISO', :ret_value=undef, :vTimeStamp='09/29/2003 11:52:16
 ', :vNode='MISO']) at /PerlApp/ODM_process.pm line 797.

But after sub moved from the module into script then conveted to .exe. The
problem's done.

The command used to convertion is: "perlapp script.pl --add module1;module2
--lib C:\libpath\lib"

_______________________________________________
PDK mailing list
PDK@[...].com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs