.....
can we call sql scripts containing procedures and packages without a SQL*plus.
.....Yes, we can with SQLCI in place, it goes like this.
scott@ORA11G>
scott@ORA11G>
scott@ORA11G> ddl emp;
CREATE TABLE "SCOTT"."EMP"
( "EMPNO" NUMBER(4,0),
"ENAME" VARCHAR2(10),
"JOB" VARCHAR2(9),
"MGR" NUMBER(4,0),
"HIREDATE" DATE,
"SAL" NUMBER(7,2),
"COMM" NUMBER(7,2),
"DEPTNO" NUMBER(2,0),
CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE,
CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO")
REFERENCES "SCOTT"."DEPT" ("DEPTNO") ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
scott@ORA11G>
scott@ORA11G>
scott@ORA11G> ddl p;
CREATE OR REPLACE PROCEDURE "SCOTT"."P" as
begin
execute immediate ' alter index demo.t_idx rebuild nologging';
end;
/
scott@ORA11G> ddl pkg;
CREATE OR REPLACE PACKAGE "SCOTT"."PKG" as
procedure p1;
procedure p2;
end;
/
CREATE OR REPLACE PACKAGE BODY "SCOTT"."PKG" as
procedure p1 as
begin
null ;
end ;
procedure p2 as
begin
null ;
end ;
end;
/
scott@ORA11G>