Hi Team,
I am new to Apache calcite, after gone through some examples now I am able to
parse simple SQL queries using SqlParser. But here my problem is how can we
validate PLSQL quires, like declaring parameters using DECLARE key,
conditions(if) ,exec, begin,end..etc., and special characters (@ and ;) . I
gone through almost all test classes which you provided, but there are no class
has below mention example syntax.
Ex:
DECLARE @lclIstelescopeEnabled bit
DECLARE @lclMeasureUnit varchar(30)
set @lclIstelescopeEnabled = 0
SELECT @lclIstelescopeEnabled =Isnull(is_telescope_enabled, 0),
@lclMeasureUnit = measure_unit
FROM forecast_plan
SELECT @lclWeekTypeID = period_type_id
FROM period_type_map
WHERE period_type_name = 'WEEK'
if (exists (SELECT name, type
from sysObjects where type in ('P', 'FN')
and lower(name) = lower('DT_FORECAST_DATA_pre')))
begin
exec DT_FORECAST_DATA_pre
end
Requirement: Above quiry I'll get from client and I'll append this query to
procedure and deploy that. Before deploy I should validate queries.
I really appreciate any help you can provide .
Thanks,
Raghavender Reddy Erupaka
Software Engineer
Steelwedge Software, Inc.
cell 9030684174
www.steelwedge.com<http://www.steelwedge.com/>
[SW New Signature Logo]
Plan. Perform. Profit.
CONFIDENTIALITY NOTICE This message, including any attachments, contains
confidential information and may contain information that is also proprietary
and/or privileged. If you are not the intended recipient, you are hereby
notified that any disclosure, copying, distribution or use of this message is
strictly prohibited. If you have received this message in error, please notify
us immediately by replying to this e-mail and then delete this message and its
attachments from your system. Thank you.
