How create oracle type object in tibero database

963 views Asked by At

How in tibero databse create type object, here code of oracle

Create or Replace Type tst_type As Object(
param1 VarChar2(4000),
param2    VarChar2(10),

Static Function statfunc1 ( sctx In Out tst_type ) Return Number,
Member Function memberfunc1 ( Self In Out tst_type,
    value In tst_func ) Return Number);

?

1

There are 1 answers

1
cpyang On

This syntax works fine in Tibero 6.

tbSQL 6  

TmaxData Corporation Copyright (c) 2008-. All rights reserved.

Connected to Tibero.
SQL> ed
Wrote file .tbedit.sql

   1 Create or Replace Type tst_type As Object(
   2    param1 VarChar2(4000),
   3    param2 VarChar2(10),
   4    Static Function statfunc1 ( sctx In Out tst_type ) Return Number,
   5    Member Function memberfunc1 ( Self In Out tst_type, value In tst_type ) Return Number);
SQL> /

Type 'TST_TYPE' created.