SYBASE ASE 12.5
Y mena problema , pri opredelenii kyrsora , procedura otkazyvaetsa kompelirovatsa
Smysl procedyry byl pokazyavat ascii znacheniya pola kak fynkzia DUMP v Oarcle
---Text procedyry---
create procedure chardump
@colname varchar(30) ='oleg', @tblname varchar(30) ='oleg'
as
begin
declare @cplace int,@clength integer,@str varchar (7999)
declare @nn varchar(255),@test varchar(255)
declare cur cursor for select @colname from =@tblname
open cur

fetch cur into @nn
while @@sqlstatus=0
begin
select @cplace=1
select @clength = char_length(@nn)
select @str=convert(varchar(4),ascii(substring(@nn,1,1)))
while @clength>=@cplace
begin
select @cplace=@cplace+1
select @str=@str+','+convert(varchar(4),ascii(substring(@nn,@cplace,1)))
end
print @str
fetch cur into @nn
end
close cur
deallocate cursor cur
end
Oshibka: Incorrect syntax near '@tblname'

Ya sdelal probnyu prozedyry:
--Tekst probnika--
create procedure a1 @tblname varchar(20)='oleg'
as
begin
select name from @tblname
select 1
end
Oshibka: Incorrect syntax near '@tblname'
Y kogo kakie idei est , bydy ochen blagodaren . Spasibo za pomosh