Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2009
    Posts
    6

    Unanswered: scn_to_timestamp

    Dear Folks,

    I need to know the last update time on the table.i have used ora_rowscn
    that command is
    SELECT ora_rowscn FROM t .

    then given the command
    SELECT scn_to_timestamp(ora_rowscn) TIMESTAMP, COUNT(*) FROM t GROUP BY scn_to_timestamp(ora_rowscn);

    but execute the above command it show a error.
    unauthoraised datatype used.

    pls need ur help .

    pls forward your good ideas .
    thanks in advance

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    What was the exact error message (including ORA-xxxxx number)?

  3. #3
    Join Date
    Mar 2009
    Posts
    6
    dear,

    it shows the error number 'ORA-03115 :unsupported network datatype or representation'

    iam work on the toad

    please give me the ideas

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    What version of Oracle are you using? The error definition suggests you need to upgrade to resolve it:
    ORA-03115 unsupported network datatype or representation

    Cause: A user bind or define, or an Oracle function, is not supported by this heterogeneous Net8 connection.

    Action: Upgrade the older version of Oracle and try again.

  5. #5
    Join Date
    Mar 2009
    Posts
    6

    version

    sir,
    Iam using oracle version is
    Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 .

    Weather this version is support or not iam mentioned the query.

    pls give me tips.

  6. #6
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    What version of Toad?

  7. #7
    Join Date
    Mar 2009
    Posts
    6

    toad version

    Sir,

    iam using the toad version is TOAD 7.6.0.11.

    If i try in sql plus this working fine or not?

  8. #8
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    I don't know - why don't you try SQL Plus and find out?

    Your version of Toad is very old - I have Toad 9.1. Since this error message is apparently all about needing to upgrade to newer versions of tools, I would suggest that Toad 7.1 is probably too old to support what you are trying to do.

  9. #9
    Join Date
    Mar 2009
    Posts
    6

    scn_to_timestamp

    Dear sir,

    Iam tried in sql plus also.its shows the same error.
    i don't know because iam using sql plus is latest version of oracle databse 10 only
    can u clarify it.

  10. #10
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    When you start SQL Plus you get a banner message like:
    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 7 13:25:37 2009

    Copyright (c) 1982, 2005, Oracle. All rights reserved.


    Connected to:
    Oracle Database 10g Release 10.2.0.3.0 - 64bit Production
    What does yours say?

    If your SQL Plus is old, it may just not support your SQL and you may have to get your Oracle client software upgraded.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •