Creating a Procedure
737934Dec 1 2009 — edited Dec 1 2009Hi, 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