Re: exp/imp - Problems with procedures and trigger

Alexander Peters wrote:

> StefanKapitza wrote:
>
> > On Feb 12, 1:50 pm, "Alexander Peters" <apet..._at_ap-data.de> wrote:
> > > StefanKapitza wrote:
> > > > On Feb 12, 10:37 am, "Alexander Peters" <apet..._at_ap-data.de>
> > > > wrote:
> > > > > Hello NG!
> > > > > I have a problem with the tools imp and exp. When i export a
> > > > > user with exp and reimport the dump into an other user or
> > > > > server all procedures and trigger compiled with
> > > > > warnings/errors. But when i recreate the procedures (with
> > > > > SQL), they are compiled without any error. How can i export
> > > > > and import a database user without destroying the procedures
> > > > > and trigger?
> > >
> > > > > Export:
> > > > > my Parfile:
> > > > > STATISTICS=NONE userid=%1/%2
> > > > > file=%3
> > > > > log=%3.log
> > > > > exp parfile=parfile.txt
> > >
> > > > > Import:
> > > > > imp %1/%2 fromuser=%3 touser=%1 file=%4 log=%4.log
> > >
> > > > > Thanks in advance
> > > > > A. Peters
> > >
> > > > And what was the Error message ?
> > >
> > > > regards
> > >
> > > > s.kapitza
> > >
> > > Hello Kapitza,
> > >
> > > It says only
> > > IMP-00041: Warnung: Objekt wurde kompiliert aber mit einigen
> > > Warnungen (IMP-00041: Warning: object was compiled, but with
> > > warnings)
> > >
> > > The Export runs without any errors.
> > >
> > > --
> >
> >
> > maybe you could logon with the user in question
> > and query user_errors to narrow down your problem.
> >
> > regards
> >
> > stefan Kapitza
>
> Thanks for the Tipp with user_errors. I think its a characterset
> problem, because he says:
>
> PLS-00103: Fand das Symbol "`" als eines der folgenden erwartet wurde:
>
> . ( ) , * @ % & | = - + < / > at in is mod not range rem =>
> .. <an exponent (**)> <> or != or ~= >= <= <> and or like
> between ||
> Das Symbol ". wurde vor "`" eingefügt, um fortzufahren.
>
>
> But i dont know how i can solve it.

I found the error. There are two special characters in a procedure which is used by the trigger.

Thanks for help and the hint with user_errors

Greetings A. Peters

--