Skip to Content (Press Enter)
UserImage.jpg
keisuke shoji
23Views
5Comments
[Validation Helper] SQL Error with Oracle2
Question
Reactive
Forge
validationhelper
Reactive icon
Validation Helper (O11)
Forge asset by Hiroyuki Yamagami
Application Type
Reactive

We caught SQL Error in IsExistRecord.SQL1 with Oracle. I think the cause is difference of how to define Temporary Table with SQL Server and Oracle.


I'd really appreciate it if the error would be solved.

0
0
20 Sep 2022
Copy Link
2021-01-01 04-34-20
Hiroyuki Yamagami

Thanks for the feedback.
I don't have an Oracle development environment, but I will try to solve the problem.

0
0
25 Sep 2022
Copy Link
UserImage.jpg
keisuke shoji

I got it. I assumed the role of IsExistRecord.SQL1 is to implement following query.

```

SELECT COUNT(*) FROM @ReferenceTableName WHERE @ReferenceAttrName = @Value

```

So I replaced IsExistRecord.SQL1 to Extension that I made in our environment. The Extension is published in my Forge component as GeneralSelectQuery Extension.



0
0
01 Oct 2022
Copy Link
2021-01-01 04-34-20
Hiroyuki Yamagami

Version 1.2.3, which fixes the issue, is now available.
Cool component. But I fixed it before I saw your comment.

0
0
01 Oct 2022
Copy Link
UserImage.jpg
keisuke shoji

Thank you for updating. I'll check the new version.

0
0
02 Oct 2022
Copy Link
UserImage.jpg
keisuke shoji

I checked it works completely in our (Oracle) environment. Thank you!

1
0
02 Oct 2022
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.