OraFAQ Forum: Reports & Discoverer » srw.run

Home » Developer & Programmer » Reports & Discoverer » srw.run_report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

srw.run_report [message #227391]

Wed, 28 March 2007 02:28

rubi
Messages: 10
Registered: August 2006

Junior Member

i have used srw.run_report before and it is working well.
but when i develop new report which recquire that the calling and called report has a different username, i included the parameter "userid=username/password@database" it gives an error that it cannot be invoked with user id. i am using reports 6i.
thanks!

Report message to a moderator

Re: srw.run_report [message #227601 is a reply to message #227391]

Wed, 28 March 2007 14:58

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Could you use workaround? For example, create synonyms in current schema or address another schema objects using "schema.table" notation?

Report message to a moderator

Re: srw.run_report [message #227654 is a reply to message #227391]

Wed, 28 March 2007 22:32

rubi
Messages: 10
Registered: August 2006

Junior Member

thanks for your reply. however, my calling report will be accessing an mdb file while my called report will be connected to oracle sql*plus.

Report message to a moderator

Previous Topic:	printing the data tilll the bottom end of the physical page
Next Topic:	How to create report at runtime / use parameter for column (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 05:27:37 CST 2024