Integration

Dear Sir's
Kindly Help Me as i am trying to run my pro*c reports on button click with the help of host command i get Ora -12162,

I run bellow command

host('/u/upsegid/reports/sheet 00 1');

**sheet is my report and 00 1 are parameters

but my all other forms and application is working fine ,

so to test i created a demo form with one textbox and button and on button click i executed text in textbox with in host command like this

textbox value = sqlplus system/manager@orcl

and on button click i wrote

host(<textbox value>)

so i found that while i execute

sqlplus system/manager@orcl >> /u/upsegid/a.txt

command successfully executes and give sql prompt and output is redirected in a.txt

but while executing

sqlplus system/manager >> /u/upsegid/a.txt

i found same error(ORA-12162) in a.txt file

so further investigate and found that my pro*c are using "system/manager" to login insted of "system/manager@orcl" without host string

sir i cant change my proc as they are compiled ,so help where i can make change so make my server allow user to login without host string i mean like this "system/manager"

Thanks & Regards
Aashish Mishra
09936194372