Import stored procedure

Hello is there a way to import procedures stored with a dbschema without the name of the Owner at the beginning of each procedure. thank you for your help

Get my package, utils2_ak, it contains my dbschema replacement utility, myschema, which has options (-A & -O) to suppress owners or (--set-owner newownername) to replace all owners with a different one. If you don't want to use myschema, you will either have to post process the schema file, or wait couple of months to see what might be coming down the pike. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Sep 7, 2010 at 7:29 AM, ARSLAN SI YOUCEF < arslan.siyoucef@consult-ix.fr> wrote: > Hello > is there a way to import procedures stored with a dbschema without the name > of > the Owner at the beginning of each procedure. > thank you for your help > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c59a343fcd72048fad7972

"wait couple of months to see what might be coming down the pike". You tease! Panther maybe??? Bob ----- Original Message ----- From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org Sent: Tuesday, September 7, 2010 11:58:56 AM Subject: Re: Import stored procedure [21191] Get my package, utils2_ak, it contains my dbschema replacement utility, myschema, which has options (-A & -O) to suppress owners or (--set-owner newownername) to replace all owners with a different one. If you don't want to use myschema, you will either have to post process the schema file, or wait couple of months to see what might be coming down the pike. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Sep 7, 2010 at 7:29 AM, ARSLAN SI YOUCEF < arslan.siyoucef@consult-ix.fr> wrote: > Hello > is there a way to import procedures stored with a dbschema without the name > of > the Owner at the beginning of each procedure. > thank you for your help > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c59a343fcd72048fad7972 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Did I mention Panther? I couldn't mention anything about Panther, I'm under NDA. I just said that "If you don't want to use myschema...." you can wait to see if anything else becomes available over the next couple of months or edit the schema file manually. ;-) Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Sep 7, 2010 at 12:24 PM, rroussey@comcast.net <rroussey@comcast.net>wrote: > "wait couple of months to see what might be coming down the pike". You > tease! > Panther maybe??? > > Bob > > ----- Original Message ----- > From: "Art Kagel" <art.kagel@gmail.com> > To: ids@iiug.org > Sent: Tuesday, September 7, 2010 11:58:56 AM > Subject: Re: Import stored procedure [21191] > > Get my package, utils2_ak, it contains my dbschema replacement utility, > myschema, which has options (-A & -O) to suppress owners or (--set-owner > newownername) to replace all owners with a different one. If you don't want > to use myschema, you will either have to post process the schema file, or > wait couple of months to see what might be coming down the pike. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any other > organization with which I am associated either explicitly, implicitly, or > by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > On Tue, Sep 7, 2010 at 7:29 AM, ARSLAN SI YOUCEF < > arslan.siyoucef@consult-ix.fr> wrote: > > > Hello > > is there a way to import procedures stored with a dbschema without the > name > > of > > the Owner at the beginning of each procedure. > > thank you for your help > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001636c59a343fcd72048fad7972 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636ed70005e64f2048fae1d77