Hi Experts,
I am running a script from SQL*PLUS and it has a '@' character in the script it self.
So while running from SQL *PLUS it gives me the below error
SQL> @MY_SCRIPT.pkb
SP2-0310: unable to open file "WHERE_REFERENCIA.sql"
SP2-0310: unable to open file "WHERE_PLANTA.sql"
SP2-0310: unable to open file "WHERE_AGENTE.sql"
SP2-0310: unable to open file "WHERE_CODIGO.sql"
SP2-0310: unable to open file "WHERE_DESCRIPCION.sql"
SP2-0310: unable to open file "WHERE_DATECAP.sql"
SP2-0310: unable to open file "WHERE_ESTATUS.sql"
SP2-0310: unable to open file "WHERE_DATERESP.sql"
SP2-0310: unable to open file "WHERE_DATEVIG.sql"
SP2-0310: unable to open file "WHERE_DATEPLANTA.sql"
SP2-0310: unable to open file "WHERE_CUENTA.sql"
SP2-0310: unable to open file "WHERE_RAZON.sql"
Package body created.
but when I open the compiled package body in DB it is missing the lines
@WHERE_REFERENCIA
@WHERE_PLANTA
@WHERE_AGENTE
@WHERE_CODIGO
@WHERE_DESCRIPCION
@WHERE_DATECAP
@WHERE_ESTATUS
@WHERE_DATERESP
@WHERE_DATEVIG
@WHERE_DATEPLANTA
@WHERE_CUENTA
@WHERE_RAZON
When I compile it directly in SQL Developer it gives me no error but when I compile it as done above the system gives me an error.
Could you please help me get past this problem as i have to give the script to DBA and the DBA simply uses the above method to run the script.
Any help is much appreciated.
Regards,