如何在tibero数据库中创建oracle类型对象

Question

如何在tibero数据库中创建类型对象，这里是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);

Answer 1

这种语法在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.