Re: Newbie questions

Peter Morris schrieb:

> Hello ORACLE experts.
>
> We are just about to migrate a database from
> Informix to ORACLE, and I need some advice
> on the following points.
>
> Question 1)
> I have installed T.O.A.D. on my PC, and
> tried to run it. Whenever I try to establish a
> connection to a database, I get back the message:
> "could not resolve service name" Nobody here
> knows what that means.

When you have trouble with TOAD then become a member in the TOAD-mailing-list

http://www.toadsoft.com/maillist.htm

>
>
> Also, when I click on the SQL*Net Help button
> it displays :
>
> Oracle root
> |
> |---Has no Oracle_Home key
> |---Oracle Root is NOT valid
>
> How should these be set?

Didn't you install ORACLE correctly? You have to install SQL-NET for use of TOAD.
There must be in your Registry of Windows95/98/NT the following key

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE But this Registry-setting should be set correctly from the Oracle-Installer.

>
>
> Question 2)
> Can anyone give me information on Dynamic PL/SQL.
> I have seen only one example, and I don't understand the
> syntax.

This is a complex package of Oracle....btw: it is dynamic SQL...not dynamic PL/SQL
Read in the manual about the package DBMS_SQL If further questions remain, ask again.

>
>
> Question 3)
> I need to migrate some Stored Procedures which select
> multiple rows from the database, and return them to
> the calling program. How do I do this? I have seen
> no examples of such. I have seen examples of multiple
> rows selected an written to the screen using DBMS_OUTPUT.
> I have also seen examples of single values returned as
> the RETURN value of a function, or in OUT parameters,
> but no examples of what I want.

Regards, Stephan
--

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-21          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------