in reply to Re: Re: Can't execute sql
in thread Can't execute sql

Knowing the database still would help. How SP's are executed differs across databases. In Oracle, for example, I need to surround the SP to be executed with BEGIN/END statements like this: 

$sth = $dbh->prepare(" BEGIN :1:=util.end_of_day(:2); END; ");

[download]

Replies are listed 'Best First'.
Re: Re: Re: Re: Can't execute sql
by mnlight (Scribe) on Jan 28, 2003 at 20:15 UTC
    Database is Sybase user is sa.
    If I cut and paste the sql from the error message and run it on the Sybase server it works just fine. I have run it with the exec, execute and with out.
[reply]

In Section Seekers of Perl Wisdom