 Related Questions Can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures? Latest Answer : no difference ... Read Answers (9) | Asked by : Suyog How do i write a function that returnsmore than 1 records from a tablefor example in sql server there is a solution as create function f1() return table asselect * from emphow do i do the same in oracle. plz help Hi How do I call procedures which have ref cursors as parameters and print the elements in the ref cursor in PL/SQL Developer ?I executed the following code in PL/SQL Developer : CREATE OR REPLACE PACKAGE EMP_PACK ASTYPE EMPCURTYP IS REF CURSOR RETURN EMP%ROWTYPE;PROCEDURE EMP_PROC( EMP_CUR IN OUT EMPCURTYP);END EMP_PACK;CREATE OR REPLACE PACKAGE BODY EMP_PACK ASPROCEDURE EMP_PROC(EMP_CUR IN OUT EMPCURTYP) ISBEGINOPEN EMP_CUR FOR SELECT * FROM EMP;END EMP_PROC;END EMP_PACK;/When I executed the following View Question | Asked by : Divya Hi 1.What is difference between procedure and function?1. procedure may or may not return values whereas function must return value2. we can call the function in the sql statements whereas we can't call the procedureExcept these two, is there any difference between these two.2. What is pl/sql table and what is use of it. In which case, we can use it3. What is ref cursor, what is the use of it.4.how the function will return multiple values. Pls give me with examples How to run a curser for update "with hold2 in PL/SQL ?Example:declarecursor CSRtest is select * from emp for update of lastname;beginfor i in CSRtest loop...do something...call procfedure with "commit"update emp set lastname = "..." where current of CSRtest;endloop;Results in "ORA-01002: fetch out of sequence" because curser is closed after "Commit"How to "save state of curser" ?Any workaround? Read Answers (1) | Asked by : Stefan Latest Answer : We can call a function from anonymous block as a part of sql statement written in that block.eg: create or replace function fn_emp(v_empno in number)return varchar2 isbeginselect ename into v_ename from empwhere empno=v_empno;return v_ename;end;this function ... Read Answers (2) | Asked by : Anuruddha SINGH Latest Answer : Hi.....yes we can create a table by using a procedure or a function but it must be done by Dynamic SQL. Dynamic SQL is a programming technique that enables you to build SQL statements dynamically at runtime. lets say you want to create an EMP table ... Read Answers (1) | Asked by : sarada Hi all I wrote a procedure to send email via plsql procedure, It was compiled sucessfully but not working ....here is the code (actuly i added the dbms output like step1 ,step 2 to see in which step the control is going on )create or replace PROCEDURE send_test_messageIS mailhost VARCHAR2(64) := 'mail.cmcltd.com'; sender VARCHAR2(64) := 'akash.sharma@cmcltd.com'; recipient VARCHAR2(64) := 'lalit.mohan@cmcltd.com'; mail_conn utl_smtp.connection;BEGIN Tags : DBMS What is the maximum number of data string can be returned from DBMS_OUTPUT? andHow do you call a trigger from a table? Read Answers (2) | Asked by : Lisa
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
