NiceMan331
asked on
procedures with optional variables
create or replace PROCEDURE Get_ent_copy (TC in number,us in VARCHAR2) IS
Cursor c_ent IS
select * From master_gen_ledger
Where (doc_date >= st_month and doc_date <= en_month)
and tr_code =tc
and user=us;
for me , us , is optional , mean
if us , then the cursor syntax will be as above
if us = null , then the syntax will be
Cursor c_ent IS
select * From master_gen_ledger
Where (doc_date >= st_month and doc_date <= en_month)
and tr_code =tc;
how could i identify the cursor in that procedure ?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Oracle Database
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
it success
thanx