Re: Error 45 Initializing SQL * PLUS

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 12 Nov 2006 01:32:24 +0100
Message-ID: <ej4fpm$is$1@news5.zwoll1.ov.home.nl>

DA Morgan schreef:

> maq wrote:

>> this is the dump file, Do you know how can i do it correctly or
>> properly?
>>
>> -- MySQL dump 10.10
>> --
>> -- Host: localhost Database: GuiasResp
>> -- ------------------------------------------------------
>> -- Server version 5.1.11-beta
>> /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
>> /*!40103 SET TIME_ZONE='+00:00' */;
>> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
>> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
>> FOREIGN_KEY_CHECKS=0 */;
>> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE,
>> SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ORACLE' */;
>> /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
>>
>> /*!40000 ALTER TABLE GUIAS.GuiBancos DISABLE KEYS */;
>> LOCK TABLE GUIAS.GuiBancos IN SHARE MODE;
>> @
>>
>> @
>> INSERT INTO "GuiBancos" VALUES
>> ('4-022','2006-09-22','2006-09-22','2-793264','253.5500',0,0,'','0','200609')...................
>>
>>

> 
> Please note at the top: "-- MySQL dump 10.10"
> 
> What does any of this have to do with Oracle?

It should be regarded as a comment line by SQL*Plus. The OP is getting an error.

To the OP: Try to remove the empty ";" signs on the comment lines. Comment lines for Oracle exist in two sorts: the ones that have two minuses, and the ones that start off with /* and end with */.

(the /*...*/ used to be documentation, as the DOC directive, the -- a real comment)

You now have -as far aas Oracle is concerned- a couple of lines like:

-- MySQL dump 10.10
--
-- Host: localhost    Database: GuiasResp
-- ------------------------------------------------------
-- Server version       5.1.11-beta
;
;
;
;
;

;
;
LOCK TABLE GUIAS.GuiBancos IN SHARE MODE; @
etc. etc.

I cannot reproduce the error 45, not with the snippet you provided

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Sat Nov 11 2006 - 18:32:24 CST