Message-Id: <25956.338452@fatcity.com> From: Date: Fri, 18 Jul 2003 10:17:40 -0400 Subject: help with dynamic pl/sql This is a multi-part message in MIME format. ------=____1058537860032_otVzJNUR1- Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Im playing around with it to figure out how to use it. Any idea what Im doing wrong? I think its the quotes, but I cant figure out where and Im not sure. I want to do the two execute immediates, because you do method 4 pl/sql that way(you dont know how many columns you want in an execute immediate). So I need to leave that in so I can learn how to do it. 1 declare 2 v_variable varchar2(20) := 'varchar2(20);'; 3 v_into number; 4 v_myString VARCHAR(500); 5 begin 6 v_myString := 'BEGIN 7 execute immediate 8 '' select 1 from dual into '||''''||v_into|| 9 ' end;'; 10 execute immediate v_myString; 11* end; SQLPLUS>/ declare * ERROR at line 1: ORA-06550: line 3, column 50: PLS-00103: Encountered the symbol "END" when expecting one of the following: . ( * @ % & = - + ; < / > at in mod not rem return returning <> or != or ~= >= <= <> and or like between into using is null is not || is dangling The symbol ";" was substituted for "END" to continue. ORA-06512: at line 10 ------=____1058537860032_otVzJNUR1- Content-Type: text/html; name="reply" Content-Disposition: inline; filename="reply" Message
One possibility -- probably a slim possibility: If the remote site can hook up a console server to the box, then you connect to the console server, and it will be like you are right there at the console  ... That's the theory anyway.
-----Original Message-----
From: Nelson, Allan [mailto:anelson@midf.com]
Sent: Friday, July 18, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Unix root account remote access

Get airline tickets, you are out of luck
-----Original Message-----
From: M.Godlewski [mailto:mcgodlewski@yahoo.com]
Sent: Friday, July 18, 2003 8:49 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Unix root account remote access

Thanks for the suggestion.
 
Unfortunately, there is no other account created at this point, and I don't have access to the machine it is remote.
 


Mohammed Shakir <mshakir08816@yahoo.com> wrote:
Why do not you login as you and then login as root?

It is for your protection that nobody should be able to remote login
from outside and any one who is login as root can be monitored.

HTH

--- "M.Godlewski" wrote:
> List,
>
> I want to install Oracle on a UNIX system no sys admin on board yet,
> so I get to set up the system with the Oracle account etc.
> Unfortunately, I can not log into the root account remotely. I get a
> non console message. Is there a way to allow remote root
> connections?
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.


=====
Mohammed Shakir
CompuSoft, Inc.
11 Heather Way
East Brunswick, NJ 08816-2825
(732) 672-0464 (Cell)
(732) ! 257-6001 (Home)

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mohammed Shakir
INET: mshakir08816@yahoo.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.

______________________________________________________________________________
This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance.