Database Error Code 24338
Crystal ReportsWhere is this place located?All Places SAP Crystal Reports 2 Replies Latest reply: Nov 11, 2010 3:04 PM by sharon towler error ora-24338 happened when change data source on crystal report Howard Zhang Nov 11, 2010 2:45 PM Currently Being Moderated Hi Guys:I made a report on my test envariment (this report involve stored procedure and it return a ref cursor from oracle database to the report). after i test it, i decided to move this report to the production database. However when i updated the database location, it shows me the following error:database connector error: 'ORA-24338': statement handle not executed [database wender code: 24338]then it shows:some tables could not be replaced, as no match was found in the new data source. please spacify the table required for any unmodified tables.then it shows:database connection errorall the tables and code in test database and production database are same. anyone can help me?thanksHoward 2844Views Re: error ora-24338 happened when change data source on crystal report sharon towler Nov 11, 2010 3:01 PM (in response to Howard Zhang) Currently Being Moderated after you went to databaseset datasource locationupdated it. did a mapping box come updid you then verify the database to pull in the new records or tables?i would run the query on the server to see if it returns values.you may also need to set your overqualified table name databaseset datasourcelocate the table or sp in the top boxthe + next to the sp or tableclickopen properities +overqualified table name F2enter the table or sp in therethen verify your database and try to run against the prod server Alert Moderator Like (0) Re: error ora-24338 happened when change data source on crystal report sharon towler Nov 11, 2010 3:04 PM (in response to sharon towler) Currently Being Moderated also do a search on the vendor code i found a few things Alert Mode
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in ODP.NET All PlacesDatabaseDatabase Application https://scn.sap.com/thread/1827960 DevelopmentWindows and .NETODP.NET This discussion is archived 5 Replies Latest reply on Jul 27, 2005 4:18 PM by 429473 Help with "ORA-24338: statement handle not executed" orclrunner Jul 21, 2005 5:56 PM Can someone explain why I am getting this error? The error https://community.oracle.com/thread/317711 occurs when I assign the FetchPermissions method to a new ArrayList. // CLASS CODE using System; using System.Collections; using System.Data; using Oracle.DataAccess.Client; namespace SurgAuthenication { public class UserAuthenicate { // get user permissions for all folders public ArrayList FetchPermissions(string usr, string srv) { string connectString = ""; if ( srv.ToLower() == "demo" ) { connectString = "Data Source=surgdemo;User ID=surgery;Password=server;pooling=false"; } else { connectString = "Data Source=surgsrv.wrightpatterson.afmc.ds.af.mil;User ID=surgery;Password=server;pooling=false"; } ArrayList al = new ArrayList(); string sql = "SELECT access_buckslip, " + "access_messaging, " + "access_scheduling, " + "access_supplies, " + "access_anesthesia, " + "access_reports, " + "access_admin " + "FROM users " + "WHERE LOWER(username) = LOWER('"+usr+"')"; IDataReader odr = GetDataReader(sql, connectString); while ( odr.Read() ) { al.Add(odr["access_buckslip"].ToString()); al.Add(odr["access_messaging"].ToString()); al.Add(odr["access_scheduling"].ToString()); al.Add(odr["access_supplies"].ToString()); al.Add(odr["access_anesthesia"].ToString()); al.Add(odr["access_repo
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack http://stackoverflow.com/questions/11991773/ora-24338-statement-handle-not-executed Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-24338: Statement handle not executed up vote 1 down vote favorite i'm using Delphi 7, database error Oracle 10, and ODAC Components. From the LoadTrainResult method I'm calling a storedProc. procedure TfrmTrain.LoadTrainResult; begin StoredProc.StoredProcName := 'PTRAIN.QTRAIN'; StoredProc.Prepare; try StoredProc.ParamByName('P_COURSE').AsString := CurrentSearch.Course; StoredProc.ParamByName('P_TOPIC').AsString := CurrentSearch.Topic; StoredProc.ParamByName('P_EMP').AsString := CurrentSearch.Emp; StoredProc.Open; finally StoredProc.Close; end; end; The schema is Create or replace PACKAGE TRAIN.pTRAIN IS TYPE CursorType IS REF CURSOR; PROCEDURE QTRAIN (p_CursorVar OUT CursorType, p_Course in VarChar2, p_Topic in out VarChar2, p_emp in Varchar 2 ); END TRAIN.pTRAIN; create or replace database error code PACKAGE BODY TRAIN.pTRAIN IS PROCEDURE QTRAIN (p_CursorVar OUT CursorType, p_Course in VarChar2, p_Topic in out VarChar2, p_emp in Varchar 2 ) IS BEGIN if p_course is not null then OPEN p_cursorvar for select * from train.course where course = p_Course; elsif p_topic is not null then OPEN p_cursorvar for select * from train.topic where topic = p_topic; end if; Exception WHEN OTHERS THEN p_TOPIC := ''; END QTRAIN; END TRAIN.pTRAIN; When i'm compiling the package i didnt get any error. How ever when im running the application Im getting an error ORA-24338: Statement handle not executed. I debugged my application, I found out that the error happened at StoredProc.Prepare; not at StoredProc.ExecProc; I had read so many posts regarding the ORA-24338 and I was unable to find out what is wrong with my code. I found that when im adding an else condition into the storedproc i didnt get the error. The modified Proc is create or replace PACKAGE BODY TRAIN.pTRAIN IS PROCEDURE QTRAIN (p_CursorVar OUT CursorType, p_Course in VarChar2, p_Topic in out VarChar2, p_emp in Varchar 2 ) IS BEGIN if p_course is not null then OPEN p_cursorvar for select * from train.course where course = p_Course; elsif p_topic is not null then OPEN p_cursorvar for select * fr