Simple sqlplus question: execute stored procedure - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Simple sqlplus question: execute stored procedure

Simple sqlplus question: execute stored procedure# Database - 数据库

c*t2008-08-06 07:08

1 楼

Wrapped a select statement with a stored procedure, not like SQL Server, in
sqlplus, can't simplely: execute sp_Test('param1') to list all records, has
to use cursor. Any sample to list the selections?

c*t2008-08-06 07:08

2 楼

found solutio:
variable c refcursor
exec WhateverProcedure(:c)
print c

in
has

【在 c**t 的大作中提到】

: Wrapped a select statement with a stored procedure, not like SQL Server, in
: sqlplus, can't simplely: execute sp_Test('param1') to list all records, has
: to use cursor. Any sample to list the selections?