[MDEV-20566] How to use PLSQL table type in MariaDB? - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Not a Bug
Affects Version/s: 10.3.14
Fix Version/s: N/A
Component/s: Parser
Labels:
None
Environment:

Hide
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)"

Show
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

Attachments

Activity

People

Assignee:: Unassigned

Reporter:: Naveenkumar

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2019-09-12 08:14

Updated:: 2019-10-06 16:12

Resolved:: 2019-10-06 16:12

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.