Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
create or replace PROCEDURE sp_test ( P_CURSOR OUT sys_refcursor ) IS BEGIN OPEN P_CURSOR FOR SELECT columnA, columnB FROM table EXCEPTION WHEN OTHERS THEN RAISE; END sp_test;
create or replace PROCEDURE sp_test ( columnA OUT table.columnA%TYPE, columnB OUT table.columnB%TYPE ) IS BEGIN SELECT columnA, columnB INTO columnA, columnB FROM table EXCEPTION WHEN OTHERS THEN RAISE; END sp_test;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|oracle database - pl sql code - for connecting to multiple databases from 1 database using database links||30||116|
|Assistance required for troubleshooting an issue - ORA-12154: TNS error - MS SQL Server 2008||3||69|
|Creating a are-you-sure condition prior to shutdown: what do you think of...||14||61|
|Trigger to update a specific column in Table B after insert or update record from Table A||13||72|
Join the community of 500,000 technology professionals and ask your questions.