Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved ORA-24334

  1. How-to
0
Votes
Undo
  1. Mitchell Ryan
    Mitchell Ryan
  2. PowerBuilder
  3. Monday, 12 June 2023 22:34 PM UTC

In the article listed below, it says to add this line to my database parameters.

timestamp=0

In PB9.2 how do I do this?

 

Thank you.

https://www.appeon.com/developers/get-help/knowledgebase/ora-24334-no-descriptor-position.html

Rearanged source code and Git merge conflicts
NTLM authentication
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 12 June 2023 23:42 PM UTC
  2. PowerBuilder
  3. # 1

Hi Mitchel;

  That would be in the DBParm field. For example...

SQLCA.DBPARM="timestamp=0"

Regards ... Chris 

Comment
David Peace (Powersoft)
  1. David Peace (Powersoft)
  2. Tuesday, 13 June 2023 09:30 AM UTC
This might help: https://www.appeon.com/developers/get-help/knowledgebase/ora-24334-no-descriptor-position.html

  1. Helpful
There are no comments made yet.
Mitchell Ryan
Mitchell Ryan Accepted Answer Pending Moderation
  1. Tuesday, 13 June 2023 14:57 PM UTC
  2. PowerBuilder
  3. # 2

Chris:

Thank you.   I get that needs to be done.  What I don't get is the mechanics of how to get that line into my application.

I have never done anything like this before.

 

Mitchell

Comment
David Peace (Powersoft)
  1. David Peace (Powersoft)
  2. Tuesday, 13 June 2023 15:27 PM UTC
When you application is connecting to the database it will be populating values in sqlca or other transaction object. You just need to check what values are in the dbparm at the point that it the connect; occurs and then edit that value to insert the additonal dbparm value.



I have just checked in one of our old Oracle applications and it has code like this:



SQLCA.DBMS = "ORA Oracle"

sqlca.logid = db_user

sqlca.logpass = db_password

//Default Database Name

sqlca.servername = '@' + db_connect

sqlca.dbparm = 'DisableBind=1'

connect;

if sqlca.sqlcode <> 0 then

MessageBox ("Cannot Connect to Database", sqlca.sqlerrtext)

return -1

end if



You could just change the dbparm line to:

sqlca.dbparm = 'DisableBind=1, timestamp=0'



Hope that helps



David
  1. Helpful 2
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.