|
From: Colin B. <Col...@as...> - 2003-08-25 03:49:06
|
The Oracle plugin currently displays the stored procedure source (no editing). It works for me but some people have reported it doesn't work = for them. It needs somebody who knows Oracle as well as java to take a look = at it. Any volunteers? Col > -----Original Message----- > From: John K. Watson [mailto:jo...@sl...] > Sent: Saturday, 23 August 2003 11:25 > To: Dani Hernandez; squ...@li... > Subject: Re: [Squirrel-sql-users] The stored procedures >=20 >=20 > If someone would write an enhancement/plugin which would enable the =20 > easy editting of stored procs/triggers in squirrel, it would=20 > become a =20 > serious alternative to TOAD and SQL-Navigator. Then, we just need =20 > editting java stored procs to make it complete. :) >=20 > John >=20 > On Thursday, Aug 21, 2003, at 00:34 US/Pacific, Dani Hernandez wrote: >=20 > > On Oracle, you can get all your source code from a system=20 > view that =20 > > filters > > for each user his sources: > > > > select * from user_source; > > > > Where you can filter with where clauses by TYPE (FUNCTION,=20 > PROCEDURE, > > PACKAGE, ...) or NAME. > > > > You cannot edit this code with update querys, but. > > > > Dani. > > > > ----- Original Message ----- > > From: "Colin Bell" <Col...@as...> > > To: "'aj...@wo...'" <cz0...@ti...>; > > <squ...@li...> > > Sent: Friday, August 08, 2003 5:24 AM > > Subject: RE: [Squirrel-sql-users] The stored procedures > > > > > >> To create a stored procedure in SQuirreL means executing a CREATE > > PROCEDURE > >> SQL statement. Something like > >> > >> CREATE OR REPLACE PROCEDURE PROC01 > >> AS > >> SELECT * FROM TAB01; > >> > >> Consult the documentation that came with your SQL server for more > >> information. > >> > >> To retrieve the source for your stored procedure is a=20 > little trickier. > > There > >> is no vendor-neutral way using JDBC to retrieve the source for a =20 > >> stored > >> procedure. Instead you'll have to consult the=20 > documentation that came =20 > >> with > >> your SQL server to see how to do this. Usually its stored=20 > in a table =20 > >> in > > your > >> system database. > >> > >> Col > >> > >>> -----Original Message----- > >>> From: aj...@wo... [mailto:cz0...@ti...] > >>> Sent: Thursday, 7 August 2003 17:07 > >>> To: squ...@li... > >>> Subject: [Squirrel-sql-users] The stored procedures > >>> > >>> > >>> Please can someone tell me how I can create and edit the > >>> stored procedures > >>> in Squirrel? Thanks. > >>> > >>> > >>> Betty > >>> > >>> > >>>=20 > ___________________________________________________________________ > >>> Nakreslete si svoji mapu a vyhrajte ceny z letn=ED kolekce! > >>> Soutezte s MapClubem na http://mapy.tiscali.cz > >>> > >>> > >>> > >>> > >>> > >>> ------------------------------------------------------- > >>> This SF.Net email sponsored by: Free pre-built ASP.NET sites =20 > >>> including > >>> Data Reports, E-commerce, Portals, and Forums are available now. > >>> Download today and enter to win an XBOX or Visual Studio .NET. > >>> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet > >>> _072303_01/01 > >>> _______________________________________________ > >>> Squirrel-sql-users mailing list > >>> Squ...@li... > >>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > >>> > >> > >> > >> ------------------------------------------------------- > >> This SF.Net email sponsored by: Free pre-built ASP.NET=20 > sites including > >> Data Reports, E-commerce, Portals, and Forums are available now. > >> Download today and enter to win an XBOX or Visual Studio .NET. > >> > > http://aspnet.click-url.com/go/psa00100003ave/=20 > > direct;at.aspnet_072303_01/01 > >> _______________________________________________ > >> Squirrel-sql-users mailing list > >> Squ...@li... > >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > >> > >> > > > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: VM Ware > > With VMware you can run multiple operating systems on a=20 > single machine. > > WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines > > at the same time. Free trial click =20 > > here:http://www.vmware.com/wl/offer/358/0 > > _______________________________________________ > > Squirrel-sql-users mailing list > > Squ...@li... > > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >=20 >=20 >=20 > ------------------------------------------------------- > This SF.net email is sponsored by: VM Ware > With VMware you can run multiple operating systems on a=20 > single machine. > WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines > at the same time. Free trial click=20 > here:http://www.vmware.com/wl/offer/358/0 > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >=20 |
