[MDEV-20566] How to use PLSQL table type in MariaDB? Created: 2019-09-12  Updated: 2019-10-06  Resolved: 2019-10-06

Status: Closed
Project: MariaDB Server
Component/s: Parser
Affects Version/s: 10.3.14
Fix Version/s: N/A

Type: Bug Priority: Blocker
Reporter: Naveenkumar Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

NAME="Red Hat Enterprise Linux Server"
VERSION="7.3 (Maipo)"
ID="rhel"
ID_LIKE="fedora"
VERSION_ID="7.3"
PRETTY_NAME="Red Hat Enterprise Linux Server 7.3 (Maipo)"


 Description   

Dear Team ,

I am currently using oracle 10G and planning to migrate oracle packages to mariadb packages .
I am getting below error kindly request you to help on this .

source rrbs_pkg_oss_common_spec.sql
Query OK, 0 rows affected (0.000 sec)

ERROR 1064 (42000) at line 3 in file: 'rrbs_pkg_oss_common_spec.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE t_rate_id IS TABLE OF rrbs_new_sms_rate_plan.rate_id%TYPE INDEX BY PLS_INTE' at line 7

Please find the oracle example codes in below link

https://docs.oracle.com/cd/A57673_01/DOC/server/doc/PLS23/ch4.htm

Regards
naveen

 Comments   
Comment by Elena Stepanova [ 2019-10-06 ]

MariaDB JIRA is a bug-tracking system. If you seek information or advice, please try public resources and mailing lists. Alternatively, you might want to consider acquiring a support contract. If you already have a support contract, please submit a support ticket.

Generated at Thu Feb 08 09:00:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.