Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Inner Query IN keyword is missing after converting Oracle procedure to Postgre procedure #1824

Open
rajatjha28 opened this issue Oct 3, 2024 · 0 comments

Comments

@rajatjha28
Copy link

Sample Oracle query -
CURSOR C_FACTURE_NEW IS SELECT * FROM FACTURE WHERE ACTIDGESTION = P_ACTIDGESTION AND
FACID IN (
SELECT FACID FROM DOSRUBECHEANCIER WHERE **DOSID IN (**SELECT DOSID FROM DOSSIER WHERE ACTID = P_ACTIDGESTION) );

After converting to Postgre -
C_FACTURE_NEW CURSOR FOR SELECT * FROM FACTURE WHERE ACTIDGESTION = P_ACTIDGESTION AND
FACID IN (
SELECT FACID FROM DOSRUBECHEANCIER WHERE **DOSID(**SELECT DOSID FROM DOSSIER WHERE ACTID = P_ACTIDGESTION) );

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant