perl怎么调用oracle存储过程？

cary

请问有谁知道perl怎么调用oracle存储过程？谢谢！
DBI中，把sql语句直接改为 "exec 存储过程名" 就行了吗？我试过报invalid SQL statement

apile

最後要加 ";"......

cary

这是我的程序内容，
my $sql1=qq{exec sync_content (623);};
my $cate = $dbh->prepare($sql1) or die "Can't prepare statement: $DBI::errstr";
my $rc = $cate->execute;

后台还是报DBD::Oracle::st execute failed: ORA-00900: invalid SQL statement (DBD ERROR: OCIStmtExecute) [for Statement "exec sync_content (623);"]

这个语句到底怎么写呀，弄了一天，也没结果！

ulmer

Hallo,

"exec sync_content (623);" is correct SQL syntax in Oracle?
If yes, can you execute this SQL direct under Oracle's shell? and what's happend?
Generally BDI sent SQL with $dbh->prepare(SQL) to database, the SQL syntax must
be available in this database.

regards, ulmer

cary

谢谢ulmer 和 apile ! 问题已经搞定，
my $sql1=qq{begin sync_content(?,?); end;};
my $cate = $dbh->prepare($sql1) or die "Can't prepare statement: $DBI::errstr";
my $rc = $cate->execute($sort,$i_cate_id);

ulmer

原帖由 cary 于 2006-9-1 15:12 发表
谢谢ulmer 和 apile ! 问题已经搞定，
my $sql1=qq{begin sync_content(?,?); end;};
my $cate = $dbh->prepare($sql1) or die "Can't prepare statement: $DBI::errstr";
my $rc = $cate->ex ...

Congraduation!
That is why I have indicated the SQL synatx here!

aaronvox

Informix：
$statement = <<"EOF";
        EXECUTE PROCEDURE xxx_procedure()
EOF

Oracle:
$statement = <<"EOF";
                BEGIN xxx_procedure();END;
EOF