PHP Classes

File: test.objects.sql

Recommend this page to a friend!
  Classes of Sergey Pimenov   Oracle::DB   test.objects.sql   Download  
File: test.objects.sql
Role: Auxiliary data
Content type: text/plain
Description: objects for testunit
Class: Oracle::DB
Oracle access wrapper supporting stored procedures
Author: By
Last change: added objects for tests for collections
Date: 12 years ago
Size: 1,258 bytes


Class file image Download
CREATE TABLE test (id NUMBER(*,0), dummy VARCHAR2(100 BYTE)) PCTFREE 10 INITRANS 1 MAXTRANS 255 TABLESPACE users STORAGE ( INITIAL 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 ) NOCACHE MONITORING NOPARALLEL LOGGING / CREATE OR REPLACE package util is type gen_ref_cur is ref cursor; procedure get_cursor(p_cur out gen_ref_cur); End util; / CREATE OR REPLACE package body util is procedure get_cursor(p_cur out gen_ref_cur)is Begin open p_cur for select object_name, object_type from all_objects; End get_cursor; End util; / CREATE OR REPLACE TYPE domain_names_coltype AS TABLE OF varchar2(255); / CREATE OR REPLACE PROCEDURE domain_check ( P_DOMAINS IN domain_names_coltype , P_resdata out domain_names_coltype ) AS i binary_integer:=p_domains.first; l_resdata domain_names_coltype:=domain_names_coltype(); BEGIN p_resdata:=domain_names_coltype('asd','asdasd','asdas'); END DOMAIN_CHECK; / CREATE OR REPLACE PROCEDURE domain_check2 ( P_DOMAINS IN domain_names_coltype , p_count out number ) AS BEGIN p_count:=l_resdata.count; END DOMAIN_CHECK; /