Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: beginner: packaging queries?

Re: beginner: packaging queries?

From: dombrooks <dombrooks_at_hotmail.com>
Date: 10 Apr 2007 01:43:45 -0700
Message-ID: <1176194625.556158.77880@n76g2000hsh.googlegroups.com>


It is a trivial step to turn your anonymous plsql blocks into a procedure or function, and then into a package should you choose.

Judging by the code in your other post, you can leave most of the code as is, just changing 'DECLARE' into the 'CREATE PROCEDURE...' statement. Received on Tue Apr 10 2007 - 03:43:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US