Creating a Procedure

737934

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

Robert Geier

This post is a duplicate of :- 996863

591186

Try to use the demo's from below.

[Oracle Procedures|http://www.morganslibrary.org/reference/procedures.html]

-Anantha

737934

no its different because there i was enquiring about packages and didn't receive much help, so now im enquiring about procedures and how to create one

sb92075

1) Consider using SEARCH of this forum for CREATE PROCEDURE or similar keyword search
2) Google is your friend but only when you actually use it.