Forum Stats

  • 3,852,376 Users
  • 2,264,100 Discussions
  • 7,905,055 Comments

Discussions

Creating a Procedure

737934
737934 Member Posts: 7
edited Dec 1, 2009 12:23PM in General Database Discussions
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
Tagged:

Answers

This discussion has been closed.