Blog

I have a problem with running below procedure in oracle 11g because of the JSON value feature not available in 11g. Can you please help in correcting the procedure. create or replace PROCEDURE “STANDARDIZE_ADDRESS” ( JSON_DOC IN VARCHAR2 , JSON_OUT OUT VARCHAR2 ) is CNTRY_IN VARCHAR2(100); STATE_IN VARCHAR2(100); CITY_IN VARCHAR2(100); LAT_IN VARCHAR2(100); LONG_IN VARCHAR(100); SOURCERead more

We are evaluating whether we should write stored procedure OR write inline queries. I read this link to get an opinion. I want to know pros and cons from mysql perspective as the above question is for sql-server.Read more

I want to create a function called by a trigger on oracle but in c or c++. Something like in PostgreSQL: Audit trigger in C. Or, in any case, is there support for this but in other languages like Python? Thanks!Read more

I have started a business with my partner and now we are going to make it a company i.e. PVT LTD company. So what are the legal works to do?Read more

I have some code that looks like this: EXEC StoredProcedure1 @Arguments EXEC StoredProcedure2 @Arguments Are the two datasets guaranteed to return in the called order? I am expecting two result sets to be passed back to my server code and am running into some issues and I feel the ordering may not be guaranteed. IfRead more

I have reach a support line that gave me a T-SQL Script for one DB that I now need to apply many more times. The original script goes like: IF EXISTS Procedure THEN DROP GO CREATE PROCEDURE [dbo].[Procedure] … END GO exec Procedure ‘With Arguments’ What I’m trying to do goes like: DECLARE @db_name VARCHAR(50)Read more

I’ve started a new job and I’m going into a serious internal problem about how they use Sql to perform their businesses logic activities. As far as I’ve seen, all analysis and calculations are left to the database. They even store some sql code inside a table to perform operations using exec. By contract IRead more