help with dynamic pl/sql

From: <rgaffuri_at_cox.net>
Date: Fri, 18 Jul 2003 10:17:40 -0400
Message-Id: <25956.338452@fatcity.com>

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 <an exponent (**)> <> 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"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>

<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>

<BODY>
<DIV><SPAN class=196292213-18072003><FONT face=Courier size=2>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.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">   <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma   size=2>-----Original Message-----<BR><B>From:</B> Nelson, Allan   [mailto:anelson_at_midf.com]<BR><B>Sent:</B> Friday, July 18, 2003 9:04   AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE:   Unix root account remote access<BR><BR></FONT></DIV>   <DIV><SPAN class=549580013-18072003><FONT face=Arial color=#0000ff size=2>Get   airline tickets, you are out of luck</FONT></SPAN></DIV>   <BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
    face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> M.Godlewski     [mailto:mcgodlewski_at_yahoo.com] <BR><B>Sent:</B> Friday, July 18, 2003 8:49     AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Re:     Unix root account remote access<BR><BR></FONT></DIV>
<DIV>Thanks for the suggestion.</DIV>
<DIV> </DIV>
<DIV>Unfortunately, there is no other account created at this point, and I
    don't have access to the machine it is remote.</DIV>
<DIV> </DIV>
<DIV><BR><BR><B><I>Mohammed Shakir <mshakir08816_at_yahoo.com></I></B>
    wrote:</DIV>
<DIV>
<BLOCKQUOTE

    style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid; WIDTH: 100%">Why

      do not you login as you and then login as root?<BR><BR>It is for your 
      protection that nobody should be able to remote login<BR>from outside and 
      any one who is login as root can be monitored.<BR><BR>HTH<BR><BR>--- 
      "M.Godlewski" <MCGODLEWSKI_at_YAHOO.COM>wrote:<BR>&gt; List,<BR>&gt; <BR>&gt; 
      I want to install Oracle on a UNIX system no sys admin on board 
      yet,<BR>&gt; so I get to set up the system with the Oracle account etc. 
      <BR>&gt; Unfortunately, I can not log into the root account remotely. I 
      get a<BR>&gt; non console message. Is there a way to allow remote 
      root<BR>&gt; connections?<BR>&gt; <BR>&gt; <BR>&gt; <BR>&gt; <BR>&gt; 
      ---------------------------------<BR>&gt; Do you Yahoo!?<BR>&gt; The New 
      Yahoo! Search - Faster. Easier. Bingo.<BR><BR><BR>=====<BR>Mohammed 
      Shakir<BR>CompuSoft, Inc.<BR>11 Heather Way<BR>East Brunswick, NJ 
      08816-2825<BR>(732) 672-0464 (Cell)<BR>(732) ! 257-6001 
      (Home)<BR><BR>__________________________________<BR>Do you Yahoo!?<BR>SBC 
      Yahoo! DSL - Now only $29.95 per month!<BR>http://sbc.yahoo.com<BR>-- 
      <BR>Please see the official ORACLE-L FAQ: http://www.orafaq.net<BR>-- 
      <BR>Author: Mohammed Shakir<BR>INET: mshakir08816_at_yahoo.com<BR><BR>Fat 
      City Network Services -- 858-538-5051 http://www.fatcity.com<BR>San Diego, 
      California -- Mailing list and web hosting 
      services<BR>---------------------------------------------------------------------<BR>To 
      REMOVE yourself from this mailing list, send an E-Mail message<BR>to: 
      ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the 
      message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of 
      mailing list you want to be removed from). You may<BR>also send the HELP 
      command for other information (like subscribing).</BLOCKQUOTE></DIV>

<P>
<HR SIZE=1>

Do you Yahoo!?<BR><A
href="http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com">The New Yahoo! Search</A> - Faster. Easier. Bingo.</BLOCKQUOTE>

  <P>______________________________________________________________________________<BR>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. Received on Fri Jul 18 2003 - 09:17:40 CDT