Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Mumbai
    Posts
    1

    Post Unanswered: Transaction Handling in Oracle 9i File System

    Hi,

    I want to know more about 9i File System Transaction Handling through Java code.

    There are two schema's A and B,schema A having 9i File System tables and other schema B having some other tables. Once I save some data in 9i FS, then some exception occurs while saving data in Schema B, is there any way I can rollback whatever I saved in 9IFS?

    What options are available to implement this peculiar condition?
    I am facing this problem since I have two different schemas.

    Thanks for the solutions.

    Regards
    Badrinarayanan

  2. #2
    Join Date
    Aug 2003
    Posts
    2
    Hi,

    try that:
    SELECT TO_NUMBER('1A000', 'xxxxxxxxxx') FROM dual;

    And on the reverse way:
    SELECT to_char(4555, 'xxxxxx') from dual;

    Have a good day

Posting Permissions

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