rem 
rem $Header: oci24.sql 10-jan-97.13:43:58 echen Exp $ 
rem 
Rem  Copyright (c) 1995, 1997 by Oracle Corporation 
Rem    NAME
Rem      oci24.sql 
Rem    DESCRIPTION
Rem	 Script for A22400 OCI Techniques White Paper
Rem      Demo script for oci24.c
Rem    MODIFIED   (MM/DD/YY)
Rem     cchau      08/18/97 -  enable dictionary protection
Rem     echen      01/10/97 -  change internal to sys/change_on_install
Rem     vraghuna   03/01/95 -  Creation
set echo on;
connect internal

REM
REM Create a new user - call it ocitest
REM
drop user ocitest cascade;
create user ocitest identified by ocitest;
grant connect, resource to ocitest;

REM
REM Created needed tables 
REM
connect ocitest/ocitest;

create table oci24tab (ename char(10), empno number, sal number);

create or replace package oci24pkg as

procedure oci24proc(
	name in oci24tab.ename%type,
	salary out oci24tab.sal%type);

procedure oci24proc(
	id_num in oci24tab.empno%type,
	salary out oci24tab.sal%type);

function oci24proc (
	name oci24tab.ename%type) return number;

end oci24pkg;

 
