On Dec 29, 2:30 pm, zalesam <bindu.rang...@gmail.com> wrote:
> As, the procedures I have to write and debug are hundreds of lines and
> will be in packages and I will have to work on those scripts on my
> local file system and only when everything works fine I should check
> in the code to the database.
> Hence I want to know how to execute such procedures which are in
> source scripts ?
>
> Thanks,
> Hima
>
You can't, you need to create the packages/procedures within Oracle.
Only then can you execute them as you've written them; you cannot
selectively read the source script and only execute what you want from
it.
Of course you COULD write these procedures as anonymous PL/SQL blocks
first, execute those from scripts then modify them to be procedures in
a package. Why you'd do that much work is beyond my understanding
when you can simply write the package and package body, create/replace
them, then execute the procedures from within the package context as
I've illustrated a number of times in this thread.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
