Forum Discussion
FYI, the extension as it is currently written only supports MSSQL and MYSQL. Support for Oracle would need to be added so, if you did so, I'd like to see what code you changed and how you implemented it.
Hello
I am not sure what I have to update for Oracle SQL. I was under impression that I should give required parameters for Databse Type and Name. I didn't modify the code given except inputting servernames and credentials. I have attached the properties details of my Oracle SQL developer.
I've attached the file too to this post.
Please give a look and advise me further
Thanks a lot
Regards
Eswara V
- tristaanogre6 years agoEsteemed Contributor
OK... first of all.... you copied my sample code from bitbucket... which, by itself, isn't bad... however, that code is in JavaScript/JScript... based upon the extension of the file you sent me, you're writing your code in VBScript. Syntax is ENTIRELY different so, that's why it won't work as written. You'll need to adapt my code for VBScript.
Secondly, since you need this done for Oracle, I can modify my extension to support Oracle connection strings... This will take a bit to do so, probably a few hours, but I don't mind. However, understand that I don't have an Oracle DB server to test this on so I can make what LOOKS to be right but I can't make any guarentees it works until you try it.
Thirdly, the following line is incorrect, even in Javascript:
queryObject = SQLUtilities.NewQueryObject(Update student_course_enrolment Set WITHDRAWN_DATE = '01-AUG-18' where STUDENT_COURSE_ENROLLEMNT_ID IN (Select STUDENT_COURSE_ENROLLEMNT_ID from student_course_enrolment where student_id = XXXXXXX AND WITHDRAWN_DATE IS null ; ))
The reason being is that the query that you send to NewQueryObject needs to be a string. There are no string symbols around your query so it's not going to be able to determine what's the query... it's going to just fail at this point. Again, you'll need to make the necessary changes for VBScript but, in JavaScript, it should look like
queryObject = SQLUtilities.NewQueryObject("Update student_course_enrolment Set WITHDRAWN_DATE = '01-AUG-18' where STUDENT_COURSE_ENROLLEMNT_ID IN (Select STUDENT_COURSE_ENROLLEMNT_ID from student_course_enrolment where student_id = XXXXXXX AND WITHDRAWN_DATE IS null ; "))
So... give me some time to get the extension updated for Oracle...
- tristaanogre6 years agoEsteemed Contributor
FYI, one of the pros of script extensions is that ANYONE can edit a script extension, not just the developer. Change the extension from tcx to zip, open it in your favorite compression utility, find the code file, edit, update the zip, change the extension to tcx... and you're golden.
- contacteswart6 years agoOccasional Contributor
Hello
Appreciate your patience. Thanks for detailed extension.
I dont have any restrictions if it is VB or Java. I want to insert it as a Run Script and call it after every execution so that Withdrawn date is populated with some previous date so that product gets un-enrolled from user.
For the ease of connection string , I am able to connect to database to add a Db check point. Connection string is as given below
Provider=MSDASQL.1;Persist Security Info=False;User ID=enterprise_uat4;Data Source=UAT4.
Password you can keep it blank I will fill it out
I am also exploring it from db check point side where in I can write a custom Query in the last page of the wizard. However after writing it I am receiving the following error message
Database check point > Connection details > Custom Query > paste the following query
"Unable to execute SQL query
Command Text doesnt not return a result set "
SQL statement
Update student_course_enrolment
Set WITHDRAWN_DATE = '01-AUG-18'
Where STUDENT_COURSE_ENROLLEMNT_ID IN
(Select STUDENT_COURSE_ENROLLEMNT_ID from student_course_enrolment where student_id = XXXXXXX AND WITHDRAWN_DATE IS null );My query doesn't return any value instead it will update Withdrawn date with some previous date so that product gets un-enrolled.
Thanks
Eswara V
Related Content
Recent Discussions
- 5 hours agoSvetaG