Procedures VS Functions
Procedures are traditionally the workhorse of the coding world and functions are traditionally the smaller, more specific pieces of code. In general, if you need to update the chart of accounts, you would write a procedure. If you need to retrieve the organization code for a particular GL account, you would write a function.
Here are a few more differences between a procedure and a function:...
DEVELOPERatHTS
Last Activity: Jul 10 '07, 09:36 PM
Joined: Jun 26 '07
Location:
-
-
When you say Oracle, you mean PL/SQL or RDBMS concepts.
'PL/SQL Programming by Scott Urma (Oracle Press)' is good to start from
'Expert One on One by Tom Kyte' is good for understanding the architecture and stuffLeave a comment:
-
i did not get any answers, any suggestions people? No one from Reports backgnd??Leave a comment:
-
Oracle Reports 6i on RDBMS 8i
Hi,
I am working on a requirement where I am returning a string to oracle reports which is more than 4000 characters long. As we know reports 6i has a limitation and it does not allow the diplay charaters to be more than 4000.
I am not sure how to approach this requirememnt.
This is what i have tried and have failed the purpose:
The string is being returned thr a PL/SQL function used as a select col in the query...
No activity results to display
Leave a comment: