Encountered the symbol "(" (merged 3) [message #391742] |
Fri, 13 March 2009 05:34  |
krishkumar22
Messages: 4 Registered: March 2009 Location: bangalore
|
Junior Member |
|
|
CREATE OR REPLACE PROCEDURE CC_LoadRoadNameCheckAvaliabili
(
v_frid IN NUMBER DEFAULT NULL ,
v_companyid IN NUMBER DEFAULT NULL ,
cv_1 IN OUT SYS_REFCURSOR
)
AS
v_tablename NVARCHAR2(50);
v_Sql NVARCHAR2(2000);
--@Lat numeric(18,10),
--@Lon numeric(18,10)
BEGIN
--SELECT * FROM ADDRESSPOINTS_1
v_TABLENAME := 'Addresspoints';
v_TABLENAME := v_TABLENAME || '_' || CAST(v_frid AS NVARCHAR2(10));
--SELECT * FROM @TABLENAME
--set @Sql = 'SELECT roadname+"|"+LAT+"|"+LON AS RoadName FROM '+ @TABLENAME --+''-- WHERE CompanyId='+@CompanyId+'
v_Sql := 'SELECT lat, roadname+' || '''|''' || '+CAST(LAT AS NVARCHAR(50))+' || '''|''' || '+CAST(LON AS NVARCHAR(50)) AS RoadName FROM ' || v_TABLENAME || ' WHERE ROADNAME IS NOT NULL ORDER BY ROADNAME';
OPEN cv_1 FOR v_Sql;
END;
/
|
|
|
|
|
|
|
|
|
|
|