Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

embedded SQL .vs. embedded PL/SQL in ProC

bubblefishJul 18 2012 — edited Jul 20 2012
Hello all,

Am starting to look at embedded SQL code, for first time in many years. My question is: what (if any) are the advantages of embedding PL/SQL in Pro*C (11g), instead of embedding SQL? The code I've inherited uses embedded SQL, but I thought it was a performance enhancement to use embedded PL/SQL.

Are there specific reasons / examples when 1 is better than the other? Can you not always replace embedded SQL with embedded PL/SQL in Pro*C?

Thanks in advance!

-bw
This post has been answered by Billy Verreynne on Jul 18 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 17 2012
Added on Jul 18 2012
#plsql, #sql
9 comments
552 views