Skip to Main Content

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Creating a Procedure

737934Dec 1 2009 — edited Dec 1 2009
Hi, i'm really new at using oracle so sorry if i sound a bit dim but im in desperate need of some help! I need to create a procedure which uses my sql statement! I have created my sql statement which works fine...see below:

SELECT MAX(NEW_OBJECTID) FROM DRL_CONVERSION WHERE SOURCE_OBJECTID = 'An ID Number';

The problem is however is that i need to make this into a procedure, and i have no experience with using procedures and don't even know where to start creating one! My sql statement is pretty simple, the user inputs an object ID (SOURCE_OBJECTID) and from that a new object ID (NEW_OBJECTID) is thrown back to the user! If someone could please help me create this into a procedure i would be most grateful! Thanks in advance!

Phil

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 29 2009
Added on Dec 1 2009
4 comments
266 views