| |

VerySource

 Forgot password?
 Register
Search
Author: su27mkk

Why all stored procedures suddenly fail

[Copy link]

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-8-25 22:30:01
| Show all posts
Have you changed the table structure or type?
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-8-25 23:00:02
| Show all posts
Reinstall the Oracle database, back up all table spaces, including data and tables, views, stored procedures, etc., and reinstall the database.
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-8-25 23:30:02
| Show all posts
Reinstall the Oracle database
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-8-25 23:45:01
| Show all posts
The name of the process scheme has been changed?
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 Invalid IP Address

Post time: 2020-9-5 15:45:01
| Show all posts
I also encountered the same problem. It's a wicked one. The SQL stored procedure ran fine three days ago, but it didn't work after three days. But if you re-execute alter procedure Pro_name, it's OK.
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-9-6 10:30:01
| Show all posts
Has the problem been finally solved? Continue to pay attention!
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