PL/SQL

1.How to use a REF CURSOR?

->define TYPE (TYPE L_REF_CURSOR_TYPE IS REF CURSOR)
->define a variable of that type and open for some statement and done.

2.Standards when defining a concurrent program based on a PL/SQL package.

->The proc to be attached need to have first 2 parameters as OUT named(Errbuf OUT NOCOPY VARCHAR2,retCode OUT NOCOPY VARCHAR2)

3.Calling a CONC program from pl/sql->fnd_request.submit(applname,concname,null,null,FALSE,parameters);