Collections / Table / VARRAY Type #476
Replies: 3 comments 2 replies
-
sorry for late replay as I know oracle has 2 types of array of regular types the problem will appear in 2 situation
my suggestion is:
|
Beta Was this translation helpful? Give feedback.
-
I add support for regular type array in v2.8.7. create type StringArray as table of varchar2 in go err = go_ora.RegisterType(db, "varchar2", "StringArray", nil) after that you can use
|
Beta Was this translation helpful? Give feedback.
-
I also add example for varray which is same as array object except with fixed upper limit |
Beta Was this translation helpful? Give feedback.
-
could anyone please guidance me how to implement table type as return value of stored procedure ?
here's the main go code.
this is the procedure type
and result
the stored procedure
heres from all_coll_types
here's some print result from the golang
the error is here
some note, since the data type is unknown, i think its pointer of slice
hence, the official docs does not mention any data type for table. oracle data types
my logic is maybe add something to the encode value ? or encode by type ?
sorry for bad formating. thank you
useful reference
getting user arguments
Beta Was this translation helpful? Give feedback.
All reactions