oracle 中呼叫 store procedure
oracle 中呼叫 store procedure[@more@]1 Create or replace procedure ex_ref(v_cur IN OUT sys_refcursor)
2 as
3 Begin
4 open v_cur for select first_name from emp where rownum<3;
5* end;
SQL> /
Procedure created.
SQL> var c1 refcursor
SQL> exec ex_ref(:c1);
PL/SQL procedure successfully completed.
SQL> print c1
FIRST_NAME
--------------------
Donald
Douglas
2 as
3 Begin
4 open v_cur for select first_name from emp where rownum<3;
5* end;
SQL> /
Procedure created.
SQL> var c1 refcursor
SQL> exec ex_ref(:c1);
PL/SQL procedure successfully completed.
SQL> print c1
FIRST_NAME
--------------------
Donald
Douglas
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/66634/viewspace-847857/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 關於packages中多個同名程式(procedure)的呼叫Package
- 使用call在sqlplus中呼叫procedure和funtion!SQL
- oracle sqr 報表工具之procedure定義及呼叫示例Oracle
- Oracle Wrap ProcedureOracle
- PLSQL 呼叫 返回 遊標(Cursor)PROCEDURESQL
- mybatis3呼叫瀚高procedure報錯MyBatisS3
- 呼叫遠端procedure的2個問題
- How to rename an Oracle stored procedureOracle
- Oracle stored procedure to send emailOracleAI
- Building a Dynamic Oracle ETL ProcedureUIOracle
- [Developer] Oracle send mail procedure(2)DeveloperOracleAI
- oracle父儲存過程呼叫子儲存過程procedure與輸出引數Oracle儲存過程
- Spring 呼叫 Stored Procedure 並獲取返回值Spring
- 遠端呼叫procedure可能會有一些缺陷!
- 找到procedure中reference的物件物件
- Oracle之procedure的基礎使用Oracle
- [Developer] Oracle sendmail procedure(1)(轉載)DeveloperOracleAI
- oracle儲存過程(procedure)中執行動態SQL小記Oracle儲存過程SQL
- Oracle Display the process of the procedure ( oracle pipe , dbms_output , prompt )Oracle
- [Procedure]Oracle之分頁儲存過程Oracle儲存過程
- 用Oracle傳送郵件procedure (zt)Oracle
- Oracle 基礎 ----procedure(儲存過程)Oracle儲存過程
- mysql procedure 中 repeat &cursor 的用法。MySql
- 觸發器trigger中呼叫包package(包中含:儲存過程procedure及函式function)_plsql觸發器Package儲存過程函式FunctionSQL
- procedure儲存過程呼叫dba字首的字典dba_objects儲存過程Object
- java中呼叫ORACLE儲存過程JavaOracle儲存過程
- Oracle SQLPLUS中DEFINE在SHELL中的呼叫OracleSQL
- Oracle如何限制非法呼叫包中過程Oracle
- Jsp中呼叫Oracle儲存過程JSOracle儲存過程
- How Oracle Store Number internal(zt)Oracle
- Oracle 使用者許可權獲取ProcedureOracle
- Oracle10g Wait Event Data Collection ProcedureOracleAI
- Oracle procedure,package,function,triger 閃回 恢復OraclePackageFunction
- oracle全文索引之FILTER_4_PROCEDURE_FILTEROracle索引Filter
- plsql中的procedure和function程式設計SQLFunction程式設計
- 在SQL Developer中Debug一個procedureSQLDeveloper
- mysql 的procedure 中 loop迴圈的用法。MySqlOOP
- Procedure加密加密