Thanks a lot David. Got your point. What you said is correct, I am trying to implement it the wrong way.
On Dec 29, 12:51 pm, ddf <orat...@msn.com> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
