# NAT3520 ORACLE error :1: occurred. - CALLDBPROC for Oracle **URL:** \ **Category:** Forum\ **Tags:** Adabas-Natural, Natural, Natural-on-Linux, Natural-Database-Interfaces-on-Open-Systems\ **Created:** [May 15, 2012, 9:50pm UTC](https://techcommunity.softwareag.com/t/nat3520-oracle-error-occurred-calldbproc-for-oracle/100565 "2012-05-15T21:50:57Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Kevin\_Brown1](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@Kevin\_Brown1](https://techcommunity.softwareag.com/u/Kevin_Brown1)\ **Post date:** [May 15, 2012, 9:50pm UTC](https://techcommunity.softwareag.com/t/nat3520-oracle-error-occurred-calldbproc-for-oracle/100565/1 "2012-05-15T21:50:57Z")
## I am running the following code and getting error the error: NAT3520 ORACLE error :1: occurred. TEXT: Internal ORACLE error :1: occurred. EXPL: ORACLE has encountered an internal error. ACTN: For more information see: Internal ORACLE Error Messages. So just wondering how to resolve this? can anyone help on this. - DEFINE DATA LOCAL 1 BUS\_CUSTOMER-VIEW VIEW OF BUS\_CUSTOMER 2 CUST\_NAME 01 #CUST\_NBR (N8) INIT \<10\> 01 #CUST\_NAME (A100) 01 #RESPONSE (I4) 01 #RESULT (I4) 01 #NAME (A50) END-DEFINE \* \* CALLDBPROC ‘USR.PKG\_TEST01.PR\_CUST\_NAME’ BUS\_CUSTOMER #CUST\_NBR (AD=0) #NAME (AD=A) RESULT SETS #RESULT /\*GIVING #RESPONSE READ RESULT SET #RESULT INTO #NAME FROM BUS\_CUSTOMER /\*GIVING #RESPONSE DISPLAY #NAME END-RESULT - END CREATE OR REPLACE PACKAGE BODY pkg\_test01 AS PROCEDURE pr\_cust\_name(p\_cust\_nbr IN bus\_customer.cust\_nbr%TYPE, p\_cust\_name OUT bus\_customer.cust\_name%TYPE) IS l\_cust\_name bus\_customer.cust\_name%TYPE; BEGIN SELECT cust\_name INTO l\_cust\_name FROM bus\_customer WHERE cust\_nbr = p\_cust\_nbr; p\_cust\_name := l\_cust\_name; END pr\_cust\_name; END pkg\_test01; ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [May 15, 2012, 10:37pm UTC](https://techcommunity.softwareag.com/t/nat3520-oracle-error-occurred-calldbproc-for-oracle/100565/2 "2012-05-15T22:37:32Z")
You will need to find out what actual error code Oracle sends, if this message really only prints :1: issue the Natural LASTMSG command to view the message including the error code. ---
**Author:** ![Kevin\_Brown1](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@Kevin\_Brown1](https://techcommunity.softwareag.com/u/Kevin_Brown1)\ **Post date:** [May 15, 2012, 10:47pm UTC](https://techcommunity.softwareag.com/t/nat3520-oracle-error-occurred-calldbproc-for-oracle/100565/3 "2012-05-15T22:47:07Z")
NAT3520 ORACLE error-24333 occurred. . ---
**Author:** ![Kevin\_Brown1](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@Kevin\_Brown1](https://techcommunity.softwareag.com/u/Kevin_Brown1)\ **Post date:** [May 16, 2012, 4:45pm UTC](https://techcommunity.softwareag.com/t/nat3520-oracle-error-occurred-calldbproc-for-oracle/100565/4 "2012-05-16T16:45:57Z")
Any thought or advise…? ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 2, 2021, 3:01pm UTC](https://techcommunity.softwareag.com/t/nat3520-oracle-error-occurred-calldbproc-for-oracle/100565/5 "2021-04-02T15:01:58Z")