| |

VerySource

 Forgot password?
 Register
Search
View: 759|Reply: 3

exp error

[Copy link]

1

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

Post time: 2020-2-6 20:30:01
| Show all posts |Read mode
Hello everyone
  
   I used exp to export data and reported an error. The error number reported was 19206.
   How do I resolve this.
   Thank you everyone.
Reply

Use magic Report

0

Threads

71

Posts

50.00

Credits

Newbie

Rank: 1

Credits
50.00

 China

Post time: 2020-3-27 18:30:01
| Show all posts
ORA-19206 Invalid value for query or REF CURSOR parameter

Cause: The queryString argument passed to DBMS_XMLGEN.newContext was not a valid query or REF CURSOR.

Action: Rewrite the query so that the queryString argument is a valid query or REF CURSOR.

There is a problem with the query parameter
Reply

Use magic Report

1

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

 Author| Post time: 2020-7-31 07:30:01
| Show all posts
whbilly:
The specific error content is as follows
oracle error 19206 encountered
invalid value for query or ref cursor parameter
at "sys.dbms_xmlgen", line 83
at "sys.dbms_metadata", line 345
at "sys.dbms_metadata", line 410
at "sys.dbms_metadata", line 449
at "sys.dbms_metadata", line 1156
at "sys.dbms_metadata", line 1141
How to modify the query parameters can solve this problem.
Thank you.
Reply

Use magic Report

0

Threads

71

Posts

50.00

Credits

Newbie

Rank: 1

Credits
50.00

 China

Post time: 2020-7-31 09:15:01
| Show all posts
How is your exp file or command written
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list