| New To Discoverer [message #137299] |
Wed, 14 September 2005 07:47  |
Sheetal_Yadav
Messages: 2
Registered: September 2005
|
Junior Member |
|
|
Hi all,
I am new to Discoverer.. Can anybody suggest way toimport functions in discoverer..
And please tell me why does my sql script does not get imported properly.. Is it b'coz the discoverer creates a schema of its own????
Thanks
Sheetal
|
|
|
|
|
|
| Re: New To Discoverer [message #138589 is a reply to message #137689] |
Thu, 22 September 2005 10:11  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
As for importing functions: there is no "import" of functions in Discoverer, but maybe you mean registering, that works like:
- start Discoverer Administrator, log on (no need to open a business area)
- go to tools, register PL/SQL functions
- choose new or import
- either fill in al the information (for new) or choose from the list that pops up - for the latter: this shows all the functions in all the packages in the database, so you might not want to go there 
As for the schema of it's own: yes, by creating the EUL you create and populate the EUL tables in the database. However, these are created within the userschema you choose (the EUL owner), so it's not like "Discoverer has a schema", but you decide which Oracle user account (schema) you want to contain and maintain the EUL tables/views.
The functionality of importing a SQL statement is limited to the actual content of the EUL, so you can only use tables/views and columns that are already known to the EUL. Maybe that's the reason some of your statements cannot be imported?
Hope this answers your questions?
Regards,
Sabine
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
