cinema pichodu Posted May 30, 2014 Report Posted May 30, 2014 basically i am a java developer but right working with some stored procedures..naaku ee PL/SQL asalu idea ledhu...  i need some help to execute exisisting stored procedure from toad or sql developer.  maa database lo already ee stored procedure undi which will just select the records from abc table.    PROCEDURE proc1(xyz out t_cursor)  IS  BEGIN  -- opens cursor to return default keyword records        OPEN xyz FOR         SELECT * FROM abc;   END proc1;  ippude nenu idi execute cheyalante em input pass cheyali...entha google chesina ardam avvatledu...plz help me bhayyas...  what is the command to execute this procedure and wht parameter i should pass to this.  sCo_^Y sCo_^Y CITI#H@ CITI#H@ CITI#H@
AFDBAbhimanini Posted May 30, 2014 Report Posted May 30, 2014 Sql developer lo right click kodithe run ani vuntundi ga sCo_^Y sCo_^Y
cinema pichodu Posted May 30, 2014 Author Report Posted May 30, 2014 Sql developer lo right click kodithe run ani vuntundi ga sCo_^Y sCo_^Y maaku database ki full access ivvaledu bhayya...i have execute privileges to those procedures but naaku UI lo tables and procedures kanapadavu...i have to execute them with commands onlyÂ
AFDBAbhimanini Posted May 30, 2014 Report Posted May 30, 2014 maaku database ki full access ivvaledu bhayya...i have execute privileges to those procedures but naaku UI lo tables and procedures kanapadavu...i have to execute them with commands only View access ivvaledhu kani execute access icchara??? ... lttÂ
cinema pichodu Posted May 30, 2014 Author Report Posted May 30, 2014 saukoo vay antey ammaila enakala padathava ammayila venaka kaadhu bhayyo...naa kante ekkuva feel avuthunnav evara nuvvu ani  View access ivvaledhu kani execute access icchara??? ... ltt avunu mayya...ee DBA's inthe..manakemo asale kothe ee PL/SQLÂ
k2s Posted May 30, 2014 Report Posted May 30, 2014 ammayila venaka kaadhu bhayyo...naa kante ekkuva feel avuthunnav evara nuvvu ani   take this gif & stop going after menÂ
cinema pichodu Posted May 30, 2014 Author Report Posted May 30, 2014 take this gif & stop going after menÂ
joblessjack Posted May 30, 2014 Report Posted May 30, 2014 Select stored proc/function and press yellow "thunder" button (above the tree). Than the form will be shown that gives U oportunity to enter parameters and see the "execute script". And finally U can execute procedure.
cinema pichodu Posted May 30, 2014 Author Report Posted May 30, 2014 Select stored proc/function and press yellow "thunder" button (above the tree). Than the form will be shown that gives U oportunity to enter parameters and see the "execute script". And finally U can execute procedure. front end lo kanapadu vayya ante select and press thunder aaÂ
kothagavacha Posted May 30, 2014 Report Posted May 30, 2014 this should help in SQL PLUS   var v1 refcursor; exec proc1( xyz=> :v1);print v1;
cinema pichodu Posted May 30, 2014 Author Report Posted May 30, 2014 this should help in SQL PLUS   var v1 refcursor; exec proc1( xyz=> :v1);print v1; ()>> CITI_y@R CITI_y@R entha google chesina dorakaledu bhayya naaku....really helpfull _-_  now java guys plz come....how can i execute this from JDBC code silent_I1 Â
joblessjack Posted May 30, 2014 Report Posted May 30, 2014 front end lo kanapadu vayya ante select and press thunder aa Which version Toad are u using?
Recommended Posts