Export User Objects [library]

[ThomyKay]

When exporting user objects and a library is included in the object list then the '/' sign is missing at the end of the 'create library' statement.

 

[Marco Kalter]

There is a semi-colon, which should be sufficient.

------------------
Marco Kalter
Allround Automations

 

[ThomyKay]

Solved. Was a TOAD issue. I should evangelize my colleague to use PL/SQL Developer.

 

[ThomyKay]

Not solved. In PLSQL Developer the script runs successfully in Command window. In SQLPlus (and TOAD) it doesn't. So the '/' sign needs to be there if we take SQLPlus as a reference.

 

[Marco Kalter]

Works fine for me in SQL*Plus without a trailing /. Normally you only need a / to terminate a PL/SQL section.

What is your SQL*Plus version?

------------------
Marco Kalter
Allround Automations

 

[ThomyKay]

SQLPlus version is 9.2.0.1.0

Following testcase:
The snippet is
>
prompt
prompt Creating library L_OSINFO2
prompt =========================
prompt
create or replace library L_OSINFO2
as 'c:\osinfo.dll';
/

prompt
prompt Creating type TPARAMETER2
prompt ========================
prompt
create or replace type TParameter2 as object
(
-- Author : THKRAUSE
-- Created : 7/15/2003 5:50:04 PM
-- Purpose :
-- Attributes
Name varchar2(30),
Value varchar2(100)
-- Member functions and procedures
)
/
>

This results in the following output (OK):

>
SQL> @test.sql

Creating library L_OSINFO2
=========================

Library created.

Creating type TPARAMETER2
========================

Type created.

SQL>
>

Removing the '/' after create library results in:

>
SQL> @test.sql

Creating library L_OSINFO2
=========================

Warning: Library created with compilation errors.

SQL>
>

 

[Marco Kalter]

I don't understand why this worked okay yesterday, but it does indeed fail now in SQL*Plus. We'll try to fix this.

------------------
Marco Kalter
Allround Automations