Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Location
    Dublin, Ireland
    Posts
    16

    Unanswered: Problem changing user halfway through script

    I am trying to change user halfway through the executable part of a PL/SQL script. The syntax is:
    CONNECT user/pwd@database
    and I get this error:
    "The following error has occurred:

    ORA-06550: line 13, column 4:
    PLS-00103: Encountered the symbol "CONNECT" when expecting one of the following:

    begin declare end exception exit for goto if loop mod null
    pragma raise return select update while <an identifier>
    <a double-quoted delimited-identifier> <a bind variable> <<
    close current delete fetch lock insert open rollback
    savepoint set sql execute commit forall
    <a single-quoted SQL string>
    The symbol "if was inserted before "CONNECT" to continue.
    ORA-06550: line 13, column 45:
    PLS-00103: Encountered the symbol ";" when expecting one of the following:

    . ( * @ & = - + < / > at in mod not rem then
    <an exponent (**)> <> or != or ~= >= <= <> and or like
    between is null is not || is dangling
    ORA-06550: line 16, column 6:
    PLS-00103: Encountered the symbol "DECLARE" when expecting one of the following:

    . ( * @ % & - + / at mod rem then <an exponent (**)> and or
    ||"

    Any ideas?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Any ideas?
    AFAIK, CONNECT is a SQL*PLUS command & is not vlid in PL/SQL.
    IOW, SQL*PLUS<>PL/SQL
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •